I set up an integration between Pipedrive and Google sheets. It works well and I get all the information I want. However, I would like to populate the rows when we add new information to Pipedrive. Is there a way to auto update the Google Sheet every day or everytime a record gets updated in Pipedrive?
I know the existence of the ‘find or create row’ but I’m looking for a solution that updates the row in Google Sheet when add new information to Pipedrive.
Hopefully someone here can help me and point me in the right direction.
Best answer by Danvers
To use that, you’ll need the Row ID of the row that you’d like to update, so you can tell Google Sheets where to add the data. So your Zap would look a bit like this:
- Trigger: Whatever your Pipedrive trigger is
- Action: Google Sheets - Lookup Spreadsheet Row - Find the Row that needs updating
- Action: Google Sheets - Update Spreadsheet Row - Use the Row ID from the previous step to tell the Zap which Row to update
For this to work, you need to make sure that there is a unique identifier in the Google Sheets row - something that will allow the Lookup Row to find the row that needs updating.
I hope that's clear, please let me know if you have any questions!