How to automatically create or update a contact in Apollo every time a new row is added in Google Sheets

In this how-to guide

How to automatically create or update a contact in Apollo every time a new row is added in Google Sheets
1. Set the Google Sheets trigger as “New row added”
2. Add the “Create or update contact” step in Apollo
3. Activate your playbook
Learn more about integrating with Apollo and Google Sheets
Related blog posts
More how-to guides featuring Apollo and Google Sheets

Integrationsarrow_forwardApollo Integrationsarrow_forwardApollo + Google Sheets Integrationsarrow_forward

Relay.app is an automation tool that lets you automate actions across Apollo, Google Sheets, and many other apps. In this guide, we'll show you how to automatically run the “create or update contact” action in Apollo for each row added in Google Sheets using Relay.app.

Try it in Relay.app

Google Sheets > Apollo

Trigger

Last triggered

Row added

Create or update contact

Set the Google Sheets trigger as “New row added”

A playbook always starts with a trigger that detects changes in your connected applications and responds accordingly.

Add the Google Sheets trigger to initiate your playbook's actions every time a new row is added. Click "Add trigger" in your playbook and choose "New row added" from the dropdown menu under Google Sheets.

If you still need to connect your Google Sheets account to Relay.app yet, a prompt will guide you through the process.

Add the “Create or update contact” step in Apollo

Integrate Apollo automation into your workflow to automatically create or update a contact in Apollo every time a new row is added in Google Sheets.

Click the "Add step" button, locate the "Create or update contact" automation for Apollo, and input the mandatory and relevant details.

If your Apollo account still needs to be connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Apollo account.

Activate your playbook

Activating the playbook is the last step in the process. Once you turn it on, it automatically creates or updates a contact in Apollo every time a new row is added in Google Sheets without requiring manual intervention.

To activate your playbook, click the toggle button at the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.