**To automatically send the name, phone number, and email of new contacts to Google Sheets, use the Papo (https://papo.global/) Flows module to create an automation with a new contact trigger and a webhook action. The action sends the contact data to a URL prepared in Google Sheets through an automation platform such as Zapier or Make, or through a Google Apps Script.**

This integration eliminates manual exports and keeps a lead spreadsheet always up to date. Every time a contact enters the Papo CRM, the Flow fires the webhook and records the information in a new row in Google Sheets.

## Integration overview

| Step | Where it happens | What it does |
| :--- | :--- | :--- |
| **1. Prepare the destination** | Google Sheets + external tool | Create the spreadsheet and generate a webhook URL with Zapier, Make, or Google Apps Script. |
| **2. Create the trigger** | Papo (Flows) | Define the "Contact Created" event to start the automation when a new lead enters the CRM. |
| **3. Configure the webhook** | Papo (Flows) | Add the webhook action with the destination URL and the JSON body containing name, phone number, and email. |
| **4. Receive and record** | Google Sheets | The URL receives the payload and inserts a new row in the spreadsheet with the contact data. |
| **5. Use the data** | Google Sheets / other tools | Track leads, build reports, or connect the spreadsheet to dashboards. |

## How to prepare Google Sheets to receive the data

Papo does not generate the Google Sheets URL. You need to create an endpoint that receives the JSON sent by the webhook and writes the data to the spreadsheet. There are two common ways to do this.

### Option A: no-code automation platform

Tools such as Zapier or Make let you create a "Catch Webhook," which generates a unique URL. Then you add an "Add Row" action in Google Sheets, mapping the received fields to the spreadsheet columns.

This is the recommended option for those who don't want to code. The platform handles authentication with Google and writing to the spreadsheet.

### Option B: Google Apps Script

In Google Sheets, open **Extensions > Apps Script**, paste code with the `doPost(e)` function that parses the JSON and inserts the data. Deploy it as a "Web App" with access set to "Anyone" and copy the generated URL.

This option offers more control, but it requires basic knowledge of JavaScript and of Google's deployment interface.

## Setting up the Flow in Papo

With the webhook URL in hand, go to the **Flows** module in Papo and create a new automation.

1. **Define the trigger:** choose the "Contact Created" event. This will make the Flow fire as soon as a new contact is added to the CRM.
2. **Add the webhook action:** in the Flow editor, include a **Webhook** step.
3. **Fill in the URL:** paste the address generated in Zapier, Make, or Apps Script.
4. **Keep the method as `POST`**.
5. **Build the message body in JSON** with the fields you want to export. Example:

```json
{
  "name": "{{contact.name}}",
  "phone": "{{contact.phone}}",
  "email": "{{contact.email}}"
}
```

6. **Save and activate the Flow.**

From that moment on, every new contact that enters Papo will be automatically recorded in the Google Sheets spreadsheet, with no manual action.

## Who this automation is for

- **Sales teams** that need a centralized, always up-to-date lead base.
- **Marketing analysts** who want to track the volume of contacts generated by channel or campaign.
- **Sales operations** that already use Google Sheets as a data hub and want to eliminate manual exports.
- **SDR teams** that need to trigger follow-up routines from newly registered contacts.

## Frequently asked questions

### Do I need to know how to code to set up the webhook?
Not necessarily. With Zapier or Make, the integration is done without code. Only the Google Apps Script option requires basic knowledge of JavaScript.

### Is the data sent in real time?
Yes. As soon as the "Contact Created" trigger fires in Papo, the webhook sends the data immediately to the configured URL.

### What information can I send to Google Sheets?
You can send the name, phone number, email, and other data available in the Flow variables. The exact variables can be found in the Flows module documentation.

### Can I test before activating the Flow?
Yes. You can create a test contact in Papo and check whether the row appears in the spreadsheet. You can also send a test from the tool that generated the URL.

### Does Papo provide the webhook URL?
No. The URL must be created in Zapier, Make, or Google Apps Script. Papo only sends the data to the configured address.

## Read also

- [How to export sales funnel data to Google Sheets and create custom dashboards](/hc/papo/articles/export-sales-funnel-data-google-sheets-custom-dashboards)
- [How to personalize automated messages with the contact's name and data](/hc/papo/articles/how-to-personalize-automated-messages-with-contact-data)

---
**[Start for free →](https://papo.global/?utm_source=helpcenter&utm_medium=article&utm_campaign=how-to-send-new-contact-data-to-google-sheets-via-webhook&utm_content=en)**

You can create your account and validate the automatic sending of contacts to Google Sheets with the first user for R$ 0.