- How to add rows to a Google Sheet from new Intercom tickets
- 1. Add the Intercom "Ticket created" trigger
- 2. Add the Google Sheets "Add row" automation
- 3. Turn on the playbook
- Learn more about integrating with Intercom and Google Sheets
- Related blog posts
- More how-to guides featuring Intercom and Google Sheets
How to add rows to a Google Sheet from new Intercom tickets
Add the Intercom "Ticket created" trigger
Every playbook starts with a trigger. The trigger detects changes in your connected apps and runs your playbook in response.
Click "Add trigger" and select "Ticket created" under Intercom. Then, select the relevant details. This trigger will automatically detect all the new tickets in Intercom to add new rows in Google Sheets.
If this is your first time using an Intercom integration in Relay, you'll be prompted to connect your Intercom account.
Add the Google Sheets "Add row" automation
Integrate the Google Sheets automation into your playbook to ensure the prompt addition of a new row in Google Sheets for every new ticket created in Intercom. Add a new step and select "Add row" from the list of Google Sheets automations.
Connect Google Sheets to Relay if you haven't already, then fill out the mandatory and relevant details. You can reference fields from Intercom to automatically pass along the right data.
Turn on the playbook
Activating your playbook is the final step to automate adding of a new row in Google Sheets for every new ticket created in Intercom. Once turned on, it will respond to a new ticket created in Intercom by adding a new row in Google Sheets without manual intervention.
To enable your playbook, click the toggle button located in the header. It is advisable to perform a test run of your playbook beforehand to ensure all steps work seamlessly together and reminders are being sent correctly.