Google-sheets – Sign-in with Google disabled for even the simplest script

google sheetsgoogle-apps-script

I noticed one of my scripts stopped working and was trying to debug. I couldn't get anything to work. So I created a totally blank spreadsheet and a new script and I am still getting this error:

I am not sure where to go from here. I found a way to request verification for a project, however, I want to ask other first to figure out what is going on. Is there a quota that I have missed?

Best Answer

Maybe your Google regular/commercial account reached a quota

From OAuth API Verification FAQ

Users seeing the Unverified App Screen or "Sign-in with Google temporarily disabled"

Why are users seeing this?
To protect users and Google systems from abuse, unverified apps that are accessing restricted or sensitive scopes have a 100-user quota restriction. Failure to get your app verified before making requests to sensitive or restricted scopes will result in your project's 100-user quota eventually getting exhausted and Google sign-in being disabled for your users. Learn more about Unverified apps.

Formula

=QUERY(DATA, "SELECT B WHERE A='Exit' AND G >= date '" & TEXT(NOW()-30, "yyyy-MM-dd") & "' ")

Reference

Google Spreadsheet: Count values from last 30 days

Google Sheets – Show URL to Edit Google Form Responses

Short answer

The link points to a Q&A that has two answers but non-of them looks to me to be appropiate. I.E. the code of one of answers is incomplete and both of them send emails, so the adoption is too complex to be used as a starting point.

Below is a script that is easier to adopt.

Instructions

Create a test form and note the form ID (between ../d/ and /edit in the url).
Set the form to send responses to a new spreadsheet.
You'll be redirected to the new spreadsheet. Note the active sheet name (rename it if you want) and add a header to the column to be used to hold the response edit URLs, i.e. Edit Url. NOTE: Capitalization is very important, so be very careful on how do you write it.
Go to Tools > Script editor to add a Google Apps Script project bounded to the spreadsheet.
Replace the default code with the code below (remember to edit the global variables according to your case).
Save the project, and then add an installable form summit trigger (if you get an "Authorization required" dialog, click "Review Permissions" and then "Allow").
Submit some sample responses to test the solution.

Code

/*
 * Global Variables
 */

// Form URL
var formURL = 'https://docs.google.com/forms/d/form-id/viewform';
// Sheet name used as destination of the form responses
var sheetName = 'Form Responses 1';
/*
 * Name of the column to be used to hold the response edit URLs 
 * It should match exactly the header of the related column, 
 * otherwise it will do nothing.
 */
var columnName = 'Edit Url' ;
// Responses starting row
var startRow = 2;

function getEditResponseUrls(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
  var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues(); 
  var columnIndex = headers[0].indexOf(columnName);
  var data = sheet.getDataRange().getValues();
  var form = FormApp.openByUrl(formURL);
  for(var i = startRow-1; i < data.length; i++) {
    if(data[i][0] != '' && data[i][columnIndex] == '') {
      var timestamp = data[i][0];
      var formSubmitted = form.getResponses(timestamp);
      if(formSubmitted.length < 1) continue;
      var editResponseUrl = formSubmitted[0].getEditResponseUrl();
      sheet.getRange(i+1, columnIndex+1).setValue(editResponseUrl);
    }
  }
}

Additional resources

I created a gist with the content from the question and answer. this b/c I'm exploring ways to better collaborate between end-users who write code.