Quite simply, when I receive a response from a Gravity Form, can I use Google Sheets onFormSubmit trigger to copy the newly submitted values to another sheet.
Other questions on this topic have not been answered. Google searches have eaten up a lot of time and yielded no results.
Anyone out there who can help with this?
I ran some tests since I was not able to find any documentation either. The only thing that I was able to find in the Google Documentation is this:
“An installable form submit trigger runs when a user responds to a form. There are two versions of the form-submit trigger, one for Google Forms itself and one for Sheets if the form submits to a spreadsheet.”
Which makes me assume that the “form submit” only works with Google Forms. However, I was reading the documentation of Gravity Forms and the step "HOW TO GET CLIENT ID AND CLIENT SECRET ID FROM GOOGLE DEVELOPERS CONSOLE" makes me believe that they are using Google Sheets API to makes changes on the Google Sheet.
So the best trigger to use for this situation is an On change
trigger instead. Like this one:
Since On change
is a trigger that will fire when the spreadsheet's content or structure is changed. As mentioned in the same documentation.
The API changes are taken as a change of content or structure instead of an edition or a form submission.