How to Push Pipedrive Deal Data to Google Sheets Reporting Through Zapier

Quick summary

This tutorial shows how to push Pipedrive deal data to Google Sheets using a Zapier automation, so every new deal is automatically recorded as a spreadsheet row without manual data entry. The integration uses Zapier's Zap editor to connect Pipedrive as the trigger app and Google Sheets as the action app in a few straightforward steps.

Steps

1. From your Zapier dashboard, select Zap to start building a new automation.
2. Click on the Trigger field to open the event selector.
3. Search for and select Pipedrive as your trigger app.
4. Select New Deal as the trigger event.
5. Connect your Pipedrive account to authorize the integration.
6. Click Test trigger to confirm it pulls the correct sample deal data from Pipedrive.
7. In the Action section, search for and select Google Sheets as the action app.
8. Select Create Spreadsheet Row as the action event to add a new row for each deal.
9. Connect your Google Sheets account to authorize access.
10. Select the specific spreadsheet and worksheet where deal data will be recorded, then click Continue.
11. Click Test step to verify that sample Pipedrive deal data is correctly added to your spreadsheet.
12. Once the test passes, click Publish to activate the Zap.