How to automatically add rows in Google Sheets for every update of a Pipedrive person is an automation tool that lets you automate actions across Pipedrive, Google Sheets, and many other apps. In this guide, we'll show you how to automatically run the “update row” action in Google Sheets for each person updated in Pipedrive using
Pipedrive logoPipedrive > Google Sheets
Last triggered
Pipedrive logoPerson updated
Google Sheets logoUpdate row

Set the Pipedrive trigger as “Person updated”

Add the Pipedrive trigger to initiate your playbook's actions.

To do this, click "Add trigger" in your playbook. Select the "Person updated" trigger option from the dropdown menu under Pipedrive. It will enable your playbook to identify newly updated people and trigger necessary actions automatically.

If you have yet to connect your Pipedrive account to Relay, a prompt will guide you through the connection process.


Add the “Update row” automation in Google Sheets

Integrate the Google Sheets automation into your playbook.

To add a step to your playbook, select "Add Step" and look for the "Get row" automation. Then, choose the table and sheet you want to work with; for example, let's say you want to work with the "Contacts" table. Once you've chosen the table and sheet, you must select an identifier in the "Add filter" from your sheet data to match the Pipedrive data. In this example, the identifier is "Name".

Afterward, add another step to your playbook by selecting "Update row." Next, click on all the relevant fields and fill in the necessary details such as Email, First name, Label, Last name, Name, Notes, Organization, and Phone.

If you still need to connect your Google Sheets account to Relay, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay to update rows through your Google Sheets account.


Activate your playbook

Activating your playbook is the last step to update a row for your person's profile record from Pipedrive to Google Sheets without manual intervention.

To activate your playbook, click the toggle button in the header. Before starting it, we recommend running a test to ensure all the steps work seamlessly together.

More how-to guides featuring Pipedrive and Google Sheets

See all how-to guides ➔

What will you automate?

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