How do I send Facebook Leads to specific columns in a Google Sheet via Zapier?

Question

I need to send new leads in FB into a google sheet

But here's the catch...

I only want to fill in specific columns of the spreadsheet row (the first 4 columns of the row)

However, when I create a new spreadsheet row, it clears the entire row, including the preset fields I set up in the google sheet

How do I achieve this? I tried finding tutorials online, but I cant seem to find any…

This is the 4 pieces of info I want to fill into the first 4 columns of the spreadsheet row

This is what I want to achieve

But, this is what I’m getting

All my preset drop downs and presets in the other columns of the row disappear, which i definitely don’t want

Troy Tessalone · Answer

Hi @RissheGGSheets adds new rows instead of filling in existing rows.If you want existing formulas to be populated, then you would need to include those formulas in the fields as part of the Zap step.Otherwise, look into using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations#triggers-and-actions

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded