Hi guys,
Im trying to trigger a process when a new record is created in Google Sheets. However Im stuck in mentioning the Excel File while adding the trigger. The Excel file im trying to access is the responses of a google form submission. How can do this ? I want to start a process whenever a new responses is submitted. Any help guys ?
The you need to create a file trigger and not record…when a new file or sheet is created
cheers
but every time a user submits a response, a new file is not created
anyway, those responses are stored in Google Drive as a google sheet and everytime a user submits response, a new row is added. i think the problem is almost solved. i just have to test it. Thanks anyway for your response.
1 Like