最可行的选择是有一个Web应用程序插入所需的行。您可以通过get或post方法传递表名和行号，下面的方法使用get方法
您的google脚本如下所示：

 函数insertRow（）{
 var ss = SpreadsheetAp p.getActive（）
 var sheetName = ss.getActiveSheet（）。getName（）
 var row = ss.getActiveRange（）。getRow（）
 // URL下面是链接到web应用程序，您将通过发布>部署为网络应用程序来生成它。下面是Web应用程序的代码。 
 var url =把生成的URL放在这里
 var queryString =？sheetName =+ sheetName +& rowNo =+ row $ b $ url url = url + queryString 
 Logger .log（url）
 var request = UrlFetchApp.fetch（url）$ b $ if（request！='Success'）
 Browser.msgBox（Sorry Unable to insertRow）
 } 
 

接下来，您将部署一个Web应用程序，它将处理获取请求并将新行添加到片。代码如下所示：

 函数doGet（e）{
 var SheetID =您的工作表ID在这里 
 var param = e.queryString 
 var parameters = param.split（&）
 //这只是检查只有2个参数存在否则给出无效链接
 if （param！= null&& parameter.length == 2）{
 param = e.parameter 
 var name = param.sheetName 
 var row = Number（param.rowNo）
} else {
 return ContentService.createTextOutput（Failed）
} 
 try {
 var ss = SpreadsheetApp.openById（sheetID）
 var sheet = ss.getSheetByName（name）
 sheet.insertRowAfter（row）
 sheet.getRange（row + 1,1）.setValue（Inserted Row）
} 
 catch（err ）{
 return ContentService.createTextOutput（Failed）
} 
 return ContentService.createTextOutput（Success）
} 
 

确保运行webApp一次以授予它授权/许可来编辑您的谷歌表格。
由于webApp将在您的授权下运行，因此它将能够在没有许可权的情况下插入Row。另外，您还可以向获取请求添加唯一ID（有效用户的电子邮件ID），以确保只处理来自Google表格脚本内的有效请求。

如果您想了解更多关于网络应用程序的详细信息，请点击此处： https://developers.google.com/apps-script/guides/web

I have a Google Spreadsheet containing a number of sheets, each or which I have protected using the "Except certain cells' routine in order to protect shared users from editing areas they shouldn't.

I also have a function to insert rows but this obviously fails when running as a shared user due to the protection.

The Insert Rows function works 100% with no protection added.

How can I temporarily change the active user to 'me' while the script is running and then 'remove me' when completed leaving the sheet in its original state including all the protection?

The most viable option is to have a web App to insert the row where desired. You can pass the sheet Name and row No via a get or post method. The below method uses a get method. Your google script would look something like this:

function insertRow() {
  var ss = SpreadsheetApp.getActive()
  var sheetName = ss.getActiveSheet().getName()
  var row = ss.getActiveRange().getRow()
  // Below URL is the link to  web App, you will generate it by publish >Deploy as web app. Code for Web app is below. 
  var url ="Put the generated URL here"
  var queryString = "?sheetName="+sheetName+"&rowNo="+row
  url = url + queryString
  Logger.log(url)
  var request = UrlFetchApp.fetch(url)
  if (request != 'Success')
    Browser.msgBox("Sorry Unable to insertRow")
}

Next, you will deploy a web App which will process the get request and add new rows to the sheet. The code would look like this:

function doGet(e) {
  var SheetID = "Your Sheet ID here"
  var param = e.queryString
  var parameters = param.split("&")
  // This just checks only 2 parameters are present else gives a invalid link
  if (param != null && parameters.length == 2){
    param = e.parameter
    var name = param.sheetName
    var row = Number(param.rowNo)
    } else {
    return ContentService.createTextOutput("Failed")
    }
  try{  
     var ss = SpreadsheetApp.openById(sheetID)  
     var sheet = ss.getSheetByName(name)
     sheet.insertRowAfter(row)
     sheet.getRange(row + 1,1).setValue("Inserted Row")
     }
     catch (err){
      return ContentService.createTextOutput("Failed")
     }
 return ContentService.createTextOutput("Success")
}

Make sure to run the webApp once to give it authorization/permission to edit your google sheets. Since the webApp will run under your authorization, it would be able to insert Row without an issue of permission. Also, you can add a unique ID(Email ID of the effective User?) to the get request to make sure only valid request from within the google sheets scripts is processed.

If you would like more details on the web app you can find it here: https://developers.google.com/apps-script/guides/web