Hi. I just started using paid Google Workspace and I’m getting error with Google Form extension:
ScriptError: Exception: No item with the given ID could be found. Possibly because you have not edited this item or you do not have permission to access it.
I’m the admin user and only one user on this Google workspace. I tried to install it as Individual or Admin but same error.
I’ve check all permissions in Google Admin:
Any solution?
I’ve never used the Google Form addon. Instead I use Apps Script and run this script to send data to Make from Google Forms.
var POST_URL = “YOUR_WEBHOOK_URL”;
function onSubmit(e) {
var form = FormApp.getActiveForm();
var allResponses = form.getResponses();
var latestResponse = allResponses[allResponses.length - 1];
var response = latestResponse.getItemResponses();
var payload = {};
for (var i = 0; i < response.length; i++) {
var question = response[i].getItem().getTitle();
var answer = response[i].getResponse();
payload[question] = answer;
}
var options = {
“method”: “post”,
“contentType”: “application/json”,
“payload”: JSON.stringify(payload)
};
UrlFetchApp.fetch(POST_URL, options);
};
Hope this helps!
Thank you so much. Great idea, little harder but works. There were some SyntaxError in the code but this one works:
var POST_URL = "YOUR_WEBHOOK_URL";
function onSubmit(e) {
var form = FormApp.getActiveForm();
var allResponses = form.getResponses();
var latestResponse = allResponses[allResponses.length - 1];
var response = latestResponse.getItemResponses();
var payload = {};
for (var i = 0; i < response.length; i++) {
var question = response[i].getItem().getTitle();
var answer = response[i].getResponse();
payload[question] = answer;
}
var options = {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify(payload)
};
UrlFetchApp.fetch(POST_URL, options);
}
Also for people who want to do it you need to:
- Click Save, click Run and give permissions
- Go to AppScript Triggers and add new trigger
3 Likes