About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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
Question

Need to update partially blank row in Google Sheets with info from Facebook Leads

  • 5 January 2023
  • 5 replies
  • 69 views
I

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!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
I

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.

I

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

Troy Tessalone
Userlevel 7
Badge +14

@Ideal Contact Center 

Related topics:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
SamB
Rank
Userlevel 7
Badge +11

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