How to create new tickets in Intercom from new rows added in Google Sheets

Relay.app is an automation tool that lets you automate actions across Intercom, Google Sheets, and many other apps. In this guide, we'll show you how to use Relay.app to automatically run the IntercomCreate ticket” action for each Google SheetsRow added” event.
Google Sheets logoGoogle Sheets > Intercom
Trigger
Last triggered
Google Sheets logoRow added
Intercom logoCreate ticket
1

Add the Google Sheets "Row added" 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 "Row added" under Google Sheets. Then, select the sheet. This trigger will automatically detect all the new rows added in Google Sheets to create new tickets in Intercom.

If this is your first time using a Google Sheets integration in Relay, you'll be prompted to connect your Google Sheets account.

2

Add the Intercom "Create ticket" automation

Integrate the Intercom automation into your playbook to ensure the prompt creation of a new ticket in Intercom for every new row added in Google Sheets. Add a new step and select "Create ticket" from the list of Intercom automations.

Connect Intercom to Relay if you haven't already, then fill out the mandatory and relevant details. You can reference fields from Google Sheets to automatically pass along the right data.

3

Turn on the playbook

Activating your playbook is the final step to automate the creation of new tickets in Intercom for every new row added in Google Sheets. Once turned on, it will respond to a new row added in Google Sheets by creating a new ticket in Intercom 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 sent correctly.

Google Sheets logo Google Sheets
More information
See all blog posts ➔

What will you automate?

Sign up and get started with your first Relay.app playbook today.
Background image