How-to · Lead automation

How to send Facebook & TikTok leads to Google Sheets

Build a no-code Lead Transfer automation from a Meta or TikTok lead form to Google Sheets, with an optional additional Telegram destination. Select the exact page, advertiser, and form; map fields to sheet columns; test and activate; then monitor usage and errors. Free accounts include 10 transfers per month, while active paid credits plans bill 2 shared credits from the first delivered lead.

Time
Difficulty
Beginner
Cost
0 credits(~$0.00)
Steps
5

Last reviewed: .

What you need

  • A Facebook or TikTok ad account running lead-form ads
  • A Google account with a spreadsheet to receive leads
  • Apiway account

Steps

  1. Open Lead Transfer and create an automation

    Sign in, open Lead Transfer from Apps, and create a new automation. Choose Meta Leads or TikTok Leads as the source and Google Sheets as the destination.

    Open in Apiway

  2. Connect the source and select the exact lead form

    Authorize Meta or TikTok, choose the connection, then select the Facebook Page or TikTok advertiser and the specific lead form. Use a platform test lead when the form has no sample data yet so Apiway can discover the real fields before mapping.

  3. Connect Google Sheets and map columns

    Connect Google and grant every permission checkbox shown. Select the spreadsheet and worksheet, load its header columns, then map fields or compose a template for each column. If the sheet has no header row, add one and reload columns.

  4. Add Telegram as an additional destination (optional)

    Add Telegram as another destination step in the same automation and keep the Apiway_official bot (or a connected custom bot). Under Send leads to, Just me delivers to your private chat with @Apiway_official_bot after you press Connect Telegram — no Chat ID needed; To a chat posts to a group or channel: add the bot there, send /id inside that chat and paste the Chat ID it replies with. Map the message template and test it. Each destination step delivers and retries on its own, while the lead is billed once per automation run.

  5. Test, activate, and monitor

    Run a test, fix any field or permission error, then activate the automation. New events received after activation are delivered according to the configured route; historical leads are not automatically imported. Check Usage for the monthly 10-transfer Free allowance or paid-plan credit billing and Error log for retries and recovery actions.

Common mistakes

  • Mapping the wrong lead-form fields to columns

    Fields differ by form, not just by ad account. Select the exact live form, generate or load sample data, and test the resulting row before activation.

  • Assuming it back-fills old leads

    The automation handles new events received after activation. Export and import historical leads separately if they must appear in the sheet.

Troubleshooting

  • New leads aren't appearing in the sheet — what should I check?

    Open the automation and Error log. Confirm the source connection is healthy, the selected page or advertiser and exact form match the live campaign, the automation is active, Google is connected with every requested permission, and the worksheet headers still match the mappings. Then send a new platform test lead.

  • Leads are landing in the sheet but Telegram alerts aren't firing

    Confirm the automation is active and check its Telegram step: with Just me, your Telegram must still be connected and your chat with @Apiway_official_bot must not be stopped or blocked; with To a chat, the correct Chat ID must be stored and Apiway_official or your custom bot must still be in the target group or channel with the required rights. Run its test and inspect Error log; the Sheets and Telegram steps retry independently, while the lead is billed once per automation run.

Read next

See all 21 guides