**To save new leads and deals from Papo (https://papo.global/) directly to a Google Sheets spreadsheet, you can use the Flows automation module to set up a trigger that, when activated, sends contact data via a Webhook action. This requires creating an endpoint (URL) in Google Sheets, either through an automation platform like Zapier or Make.com, or with a Google Apps Script, to receive the information sent by Papo in real-time.**

Connecting Papo to Google Sheets allows you to create a centralized, automatically updated lead database, without the need to manually export and import spreadsheets. This integration is ideal for sales, marketing, and operations teams that need visibility into generated contacts and their progress in the funnel.

## Integration Process Overview

The automation acts as a bridge between Papo and Google Sheets. When a specific event occurs in Papo (such as the creation of a new contact), the Flow is triggered and sends the data to the URL you configured.

| Step | Tool | Action |
| :--- | :--- | :--- |
| **1. Preparation** | Google Sheets & External Tool | Create the spreadsheet that will receive the data and generate a Webhook URL using a service like Zapier/Make.com or a Google Apps Script. |
| **2. Trigger** | Papo | An event happens on the platform, such as a new contact being created, a tag being added, or a deal being moved in the Kanban. |
| **3. Automation** | Papo (Flows) | The automation Flow detects the trigger and initiates the configured actions. |
| **4. Data Sending** | Papo (Webhook Action) | The Webhook action sends a data package (JSON payload) to the URL generated in Step 1. |
| **5. Receiving and Recording**| Google Sheets | The URL receives the data, and the configured logic (in Zapier or Apps Script) inserts a new row into the spreadsheet with the lead's information. |

## How to Set Up the Integration Step-by-Step

The process is divided into two main parts: first, preparing Google Sheets to receive the data, and second, configuring the automation in Papo to send it.

### Part 1: Obtain the Webhook URL in Google Sheets

Papo needs an address (URL) to send the information to. You don't create this URL in Papo, but rather in the tool that will receive the data. There are two main approaches:

**Option A: Use an Automation Platform (Recommended for beginners)**
Tools like Zapier, Make.com (formerly Integromat), or n8n are the easiest ways to connect Papo to hundreds of other applications without code.

1.  **Create an account** on one of these platforms.
2.  **Start a new automation** (a "Zap" in Zapier or "Scenario" in Make).
3.  **Choose "Webhooks"** as the trigger. Usually, the option is called "Catch Hook" or "Custom Webhook".
4.  **Copy the Webhook URL** provided by the platform. It will be unique to your automation.
5.  **Add an action** to the automation to "Add a Row" in Google Sheets. Connect your Google account, select the spreadsheet, and the columns where the data will be saved.

Leave this automation active and ready for a test.

**Option B: Use Google Apps Script (Advanced)**
If you are familiar with programming, you can create your own endpoint directly in Google Sheets.

1.  Open your Google Sheets spreadsheet.
2.  Go to **Extensions > Apps Script**.
3.  Paste code with a `doPost(e)` function that interprets the received data and adds it to the spreadsheet.
4.  Click **Deploy > New deployment**.
5.  Select "Web app" type.
6.  Configure access to "Anyone" (even anonymous), as the Papo webhook will not log into your Google account.
7.  **Copy the Web app URL** generated. This is your webhook URL.

### Part 2: Configure the Automation Flow in Papo

With the webhook URL in hand, you can now configure Papo to send the data.

1.  In the Papo dashboard, access the **Flows** module.
2.  Click to create a new Flow.
3.  **Define the Trigger:** Choose the event that will start the automation. Common examples include:
    *   **Contact Created:** To save every new lead that enters the platform.
    *   **Tag Added:** When a lead is qualified and receives a tag like "Hot Lead".
    *   **Deal Created:** When a card is created in your **Kanban** funnel.
4.  **Add the Webhook Action:** In the Flow editor, add a new step and select the **"Webhook"** action.
5.  **Configure the Action:**
    *   **URL:** Paste the URL you generated in Part 1 (from Zapier, Make, or your Apps Script).
    *   **Method:** Keep as `POST`.
    *   **Body:** Here you define which data will be sent. The format is JSON. You can use Papo variables to dynamically fill in the values.

**Example JSON body:**
```json
{
  "nome": "{{contact.name}}",
  "telefone": "{{contact.phone}}",
  "email": "{{contact.email}}",
  "etapa_funil": "{{deal.stage.name}}",
  "origem": "{{contact.channel.name}}"
}
```
6.  **Activate the Flow:** Save and activate your automation.

From now on, whenever the trigger is activated in Papo, the contact or deal data will be instantly sent to your Google Sheets spreadsheet.

### Frequently Asked Questions (FAQ)

### Do I need to know how to code to set up this integration?
Not necessarily. Using automation platforms like Zapier or Make.com, you can connect Papo to Google Sheets through a visual interface, without writing any lines of code. The Google Apps Script option is recommended only for advanced users.

### What kind of data can Papo send via webhook?
You can send almost any data associated with the contact, deal, or message, including standard fields (name, phone, email), custom attributes you have created, Kanban funnel information (deal name, value, stage), tags, and conversation details.

### Does the integration work in real-time?
Yes. The Webhook action is executed instantly as soon as the Flow trigger is activated in Papo. This means your leads will appear in the spreadsheet seconds after being created or updated on the platform.

### Can I update an existing row in Google Sheets instead of creating a new one?
Yes, but the logic for this needs to be configured in the tool that receives the webhook (Zapier, Make.com, or your script). For example, in Zapier, you can add a "Lookup Spreadsheet Row" step to check if the lead already exists (by phone or email) and then use an "Update Spreadsheet Row" action instead of "Create Spreadsheet Row".

### Where can I find the list of variables I can use in the webhook body?
Within the Papo Flow editor, when configuring the Webhook action, the platform usually offers a list of available variables (`{{contact.name}}`, `{{deal.value}}`, etc.) that you can insert into the JSON body.

---

**[Start automating your leads for free →](https://papo.global/?utm_source=helpcenter&utm_medium=article&utm_campaign=how-to-save-papo-leads-to-google-sheets-with-webhooks&utm_content=en)**

Create your Papo account to centralize your communication channels and automate sales and marketing processes.