> For the complete documentation index, see [llms.txt](https://learn.doubletick.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.doubletick.io/click-to-whatsapp/ctwa/how-to-connect-your-lead-generation-ads-to-google-sheets.md). # How to connect your lead generation ads to google sheets Learn how to send leads from Meta Instant Forms straight into a Google Sheet automatically, and how to use those leads for WhatsApp follow-ups in DoubleTick. Meta now lets you send leads from your Instant Forms straight into a Google Sheet, automatically. Earlier, teams had to download CSV files by hand or use third-party tools just to see their leads. With this built-in option, every new lead shows up in your sheet in near real time, ready for your marketing and sales teams. This article walks you through the full setup. #### What's covered * [How the flow works](#how-the-flow-works) * [What you need](#what-you-need) * [How to connect your lead ads to Google Sheets](#how-to-connect-your-lead-ads-to-google-sheets) * [What to expect after setup](#what-to-expect-after-setup) * [Using DoubleTick with Google Sheets](#using-doubletick-with-google-sheets) * [Troubleshooting](#troubleshooting) * [Key takeaways](#key-takeaways) * [Frequently asked questions](#frequently-asked-questions) * [Related articles](#related-articles) {% embed url="" %} The video shows the full workflow, from creating the campaign to setting up the Instant Form and checking the Google Sheet. If you prefer reading, follow the steps below. #### How the flow works Here is what you are setting up: Lead form → Meta → Google Sheet → DoubleTick or CRM\ Once it is set up: * Every new form submission appears in your sheet automatically. * Your team can start outreach or automation right away. * You never have to download CSV files by hand. With this setup, leads are captured instantly, delivered in real time, available to both marketing and sales, and ready to sync with tools like DoubleTick, CRMs, sales platforms, or dashboards. #### What you need * Access to **Meta Ads Manager**. * Access to a **Facebook Page**. * Permission to create **Instant Forms**. * A Google account for Google Sheets. * A DoubleTick account, if you want WhatsApp-based automations. #### How to connect your lead ads to Google Sheets * Create a lead generation campaign:\ In Meta Ads Manager, create a new campaign with the **Leads** objective. This tells Meta to show your ad to people who are more likely to share their contact details. Choose **Auction** as the buying type and continue to the ad set. * Set the ad set to Instant Forms:\ At the ad set level, Meta asks how you want to collect leads. Choose **Website and Instant Forms**. Instant Forms let people share their details right inside Facebook or Instagram, so fewer of them drop off. * Select your Facebook Page:\ At the ad level, select the **Facebook Page** for this campaign. **Instant Forms** are tied to Pages, so you need one before you can build a form. * Create the Instant Form:\ Scroll to the **Destination** section and click **Create Form**. Give the form a clear name your team can recognize later, for example "Real Estate Pune Leads". Choose a form type. We used **Higher Intent**, which adds a quick confirmation screen to cut down accidental submissions. * Choose the form fields:\ Pick the details you want to collect. In our example, we added **Full Name**, **Email**, **Phone Number**, **City**, and **State**, and kept all of them mandatory so sales has full context. You can make some fields optional to get more submissions. On the next screen, add compliance links such as your Privacy Policy, if your business needs them. * Set what happens after submission:\ Choose what people see after they submit the form, such as visiting a website, calling your business, downloading a file, or chatting on WhatsApp. For WhatsApp follow-ups, select **Chat on WhatsApp**. If your WhatsApp Business number is connected, Meta detects it automatically. Click **Create Form** to finish. * Turn on lead delivery to Google Sheets:\ Scroll down to **Automate Lead Delivery** and click **Setup**. Connect an existing sheet or create a new one. We selected **Create a new Spreadsheet** and named it "DoubleTick Test 3". Meta creates the sheet and connects it to your Google account. * Validate the connection:\ Select the worksheet (for example, Sheet 1), send a test lead, add the category and dataset labels Meta asks for, and send a final validation test. Once the test lead appears in your sheet, the automation is active. #### What to expect after setup From now on, every new lead from your Instant Forms appears in the connected sheet in near real time. This means: * No CSV downloads. * No sharing leads by hand. * Faster qualification and outreach. * A cleaner handoff between marketing and sales. * Easier automation later on. If your team relies on fast WhatsApp follow-ups, which is common in education, real estate, beauty, auto, and B2B services, this can make a big difference to your conversions. #### Using DoubleTick with Google Sheets Once your leads are in Google Sheets, DoubleTick can help you: * Trigger WhatsApp workflows. * Route leads to sales agents. * Track engagement and funnel progress. * Send bulk or automated outreach. * Qualify leads with structured logic. This gives you a full cycle, from getting the lead to activating and converting it, without manual work. If you would like help setting this up with WhatsApp automation or your CRM, the DoubleTick team can guide you through the best setup. #### Troubleshooting If leads do not appear in your sheet, try these: * Send another test lead. * Check that the campaign and form are active. * Check the access permissions on your Google account. * Make sure the correct sheet and tab are selected. Most issues are fixed by validating again or adjusting permissions, without changing the campaign. #### Key takeaways * Meta can now send Instant Form leads straight into a Google Sheet. * Use the **Leads** objective and **Website and Instant Forms** to collect leads. * Turn on **Automate Lead Delivery** and validate the connection with a test lead. * Select **Chat on WhatsApp** after submission for WhatsApp follow-ups. * With DoubleTick, you can trigger WhatsApp workflows and route leads from your sheet. #### Frequently asked questions
Do I need a third-party tool to send leads to Google Sheets? No. Meta now has a built-in option called **Automate Lead Delivery** that connects your Instant Form to a Google Sheet.
Which campaign objective should I use? Use the **Leads** objective, with **Auction** as the buying type.
How do I know the connection is working? Send a test lead during validation. If it appears in your sheet, the automation is active.
My leads are not showing up in the sheet. What should I do? Send another test lead, check that the campaign and form are active, check your Google account permissions, and confirm that the correct sheet and tab are selected.
Can I send these leads a WhatsApp message? Yes. Select **Chat on WhatsApp** as the post-submission action, and use DoubleTick to trigger WhatsApp workflows from your sheet.
#### Related articles {% content-ref url="/spaces/53n17VnOICC1LtDqlENV/pages/KUGuRdyAXCLyNn76LWHJ" %} [Getting started with Click-to-WhatsApp (CTWA) ads](/click-to-whatsapp/ctwa/getting-started-with-click-to-whatsapp-ctwa-ads.md) {% endcontent-ref %} {% content-ref url="/spaces/53n17VnOICC1LtDqlENV/pages/Ot91P0o6FKkrQ64ntADl" %} [On New Row Google Sheet](/bot-studio/triggers/on-new-row-google-sheet.md) {% endcontent-ref %} {% content-ref url="/spaces/53n17VnOICC1LtDqlENV/pages/TveI6nFruN17a79FFQrA" %} [How to Set Up Google Sheet Action](/bot-studio/actions/data-and-apis/how-to-set-up-google-sheet-action.md) {% endcontent-ref %} --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://learn.doubletick.io/click-to-whatsapp/ctwa/how-to-connect-your-lead-generation-ads-to-google-sheets.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.