Getting Started with Google Sheets' New Row Added Trigger
In this guide, you’ll learn how to configure the New Row Added trigger for the Google Sheets app. This trigger lets you automate credential issuance through Certifier Automations based on Google Sheets data. Let's get started!
Open the Trigger Configuration
To get started, click on the Trigger. The setup will be preconfigured for you – you'll just need to press Continue to move to Configuration.
Configure the New Row Added Trigger
Select or connect your Google Account via OAuth: Click on the field below Account, and select or connect a new account using + Connect New Account. This connection only permits Certifier to access files you select in the next steps.
When connecting, complete login via secure OAuth – click on Continue and Allow.
⚠️ Important: If you see this option when connecting your Google Account, make sure to tick the box for Google Drive access before pressing Continue.
This connection only permits Certifier to access files you select in the next steps.
Select the Spreadsheet and Worksheet:
Click Select Spreadsheet to choose the spreadsheet you would like to use for this automation.
Then, choose Live Sheet as the Worksheet.
Once you're ready, press Save & Continue. And that's it! Your Trigger is set up 🤓
Return to your Original Guide
Once you’ve finished the configuration, it’s critical to return to your original integration guide.
⚠️ Important: Each app has rules and limitations that apply after activation.
Every app (Google Sheets, Microsoft Excel, HubSpot, Airtable, etc.) has critical rules that apply after activation. These rules are explained at the end of your original integration guide. Be sure to return there before activating to make sure your automation works as expected.
Need more help?
If you still have some questions, do not hesitate to contact us via the chat icon or email us directly: [email protected].