Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Need to update partially blank row in Google Sheets with info from Facebook Leads

Hello, we have Zapier connected to Facebook Ads and Google Sheets, and they generally work fine on blank Spreadsheets, however, the Spreadsheet we use to capture the Lead data have some columns programmed to show the Phone Number in a clean format (Column I) or to show if the Lead information is repeated (Column J).

 

Due to this, whenever the Zap is triggered it creates a row at the very bottom of the Sheet instead of updating whichever row has blank space with the excepction of Column I and J.

 

Which would be the best way to automate the Lead Info download into this spreadsheet?

 

Thanks in advance!

Hi @Ideal Contact Center 

Good question.

I’d recommend using Airtable instead of GSheets to avoid this issue.

Airtable has Formula fields.

The formula will be applied to all records/rows.

 

Otherwise you can use ARRAY FORMULAS in the GSheet, which is an advanced approached.

Not really sure the team want to change to Airtables, they are kind of married to Google Workspace. Let me see if there is a way they know how to us Array.

Actually, I am seen that ARRAY FORMULA is the one causing all this trouble. So that is not working.

@Ideal Contact Center 

Related topics:

 

Hey @Ideal Contact Center just checking in to see if are you still running into issues here? 

If so, Troy’s suggestion of using an Array Formula or Dynamic Formula in the Zap rather than having the formula present in the Google Sheet to start with may well solve things. Having the formula set in the Zap should allow the information to be sent over into the correct row (not the bottom row) and would use the formula to format the phone numbers. 

Please do let us know if you had success with either of those options! 🙂

Terms & Conditions