How to automatically update or create a new contact in Google Contacts whenever a new row is added to Google Sheets

Relay.app is an automation tool that lets you automate actions across Google Contacts, Google Sheets, and many other apps. In this guide, we'll show you how to automatically run the “create or update contact” action in Google Contacts for each spreadsheet added to folder in Google Sheets using Relay.app.
Google Sheets logoGoogle Sheets > Google Contacts
Trigger
Last triggered
Google Sheets logoSpreadsheet added to folder
Google Contacts logoCreate or update contact
1

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.

2

Add the “Update or create contact” step in Google Contacts

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

Click the "Add step" button, locate the "Update or create contact" automation for Google Contacts, and input the mandatory and relevant details.

If your Google Contacts 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 Google Contacts account.

3

Activate your playbook

Activating the playbook is the last step in the process. Once you turn it on, it will automatically update or create a new contact in Google Contacts whenever a new row is added to Google Sheets without 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.

More how-to guides featuring Google Contacts and Google Sheets

See all how-to guides ➔

What will you automate?

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