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 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
  • Salesforce field availability when mapping to Google Sheets action - missing some fields
Best answer

Salesforce field availability when mapping to Google Sheets action - missing some fields

  • 6 July 2021
  • 4 replies
  • 113 views
F

I am populating a new Google Sheet worksheet with headers from a Salesforce record. I notice that my options of fields to pull from are limited but I am not sure why some show up as valid fields to pull while others are missing. Does anyone know what drives the fields that are able to be pulled from Salesforce? See below for the screen I am on when looking at the options to choose.

 

 

icon

Best answer by SamB 6 September 2021, 16:49

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

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @FrankP 

Can you further elaborate on the fields that you are trying to get from Salesforce?

If it’s a linked object, then you’ll have to use a Find Record step to get the details for that object.

Example, Account ID is a linked object:

 

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

Hi @Troy Tessalone , I am looking for fields that exist on the record itself, not a linked object. For example, I have custom fields that hold information I will need in the Google Sheet.

 

I have had this Zap for some time and in continuing to troubleshoot I noticed it was referencing old fields. I recreated the zap and that seemed to trigger a refresh of available fields (the ‘Refresh Fields’ button apparently wasn't doing anything). This should have fixed the issue of not seeing fields I believed should have been included.

Troy Tessalone
Userlevel 7
Badge +14

@FrankP 

Does the sample record returned when you are configuring the Zap have populated data points for these custom fields in Salesforce?

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

Just came across this and wanted to add that sometimes when a custom field isn’t appearing in the Zap it can be due to a delay between it being added to Salesforce and being “seen” by the Zap. More on that here: Custom fields/objects not loading

That said, as Troy mentioned, if the sample record pulled in from Salesforce doesn’t have a value present for the custom field that could be why it’s missing. In cases like that you’ll want to try pulling in a new sample record with a value in the missing field to see if that then allows the missing field to be selected. 

If after pulling in a new sample it’s still not loading it may be best to reach out to our Support team. They will be able to dig into the logs and set up of the Zap to investigate further. The best way to do that is by using our Get Help form.

Terms & Conditions