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.

Best answer

Help Creating Zap - Copy Google Sheet Account Name -> Extract Data from Salesforce -> Paste in GSheet

  • September 28, 2022
  • 5 replies
  • 46 views
B

Hi there,

I’m new to Zapier and looking to automate a very tedious process (I work in tech sales)

--

Current process:

  1. Have a list of account names on Google Sheets
  2. Copy the account name (per row)
  3. Paste into the Salesforce search bar
  4. Click the account name that matches
  5. Get some data from the account
    1. Ex. The Account manager name
    2. Account manager email
  6. Paste this information back into the Google Sheet row to the corresponding columns
  7. Repeat for each row (account)

--

Current zap:

 

--

Current error:

The ‘Salesforce set up action’ is not working properly. I’m assuming I’m not inputting the correct fields for:

  • Salesforce Object → Account
  • Field to search by → Account Name
  • Search Value → Account Name (from the google sheet)

The error I get is either “error 400” or “no search results found”

 

Any help/insight would be greatly appreciated!

Best answer by christina.dBest answer by christina.d

Hey there friends! I wanted to pop in and share some of the details from the support ticket.

Spoiler Alert: @Troy Tessalone nailed it.

It seems that Salesforce will only return a result if there is an EXACT match for the Account name provided….We also have a feature request to allow a fuzzy-type search (that should bring up "A. Duda & Sons, Inc." for "A. Duda & Sons, Inc")

 

Our Engineers constantly (re)prioritize open issues and the more votes we get for a feature, the better its chances are to get implemented sooner! There are multiple factors at play (such as the development effort needed or if we need to liaise with the partner in case their API needs changing, too), but as we have your vote recorded, you'll be among the first to know when this feature gets shipped! 

 

Since we’ve identified this as a feature request, we’ll also be sure to keep this topic updated here in community if and when this ships. 🙂

Thanks for raising this in community! 🧡

View original
Did this topic help you find an answer to your question?
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
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 30974 replies
  • September 28, 2022

Hi @bedoya 

Good question.

Can you confirm there is an exact match for an existing Account with the Account Name you are trying to search for in Salesforce?

 

Help article about how to change the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
christina.d
1 person likes this
  • christina.d
    christina.d
B
  • bedoyaBeginner
  • Author
  • Beginner
  • 2 replies
  • September 28, 2022
Troy Tessalone wrote:

Hi @bedoya 

Good question.

Can you confirm there is an exact match for an existing Account with the Account Name you are trying to search for in Salesforce?

 

Help article about how to change the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

Hi Troy,

 

Yup - can confirm that manually accounts exists. Although for the one shown in the screenshot (Decisionlab), there is no account there. I tried deleting that row and letting it go through the next account name but I’m getting the same error. I’m assuming its how I set up my object and field search on salesforce

B
  • bedoyaBeginner
  • Author
  • Beginner
  • 2 replies
  • September 28, 2022

Update - I refreshed it by deleting the account row that didn’t exist, and now it seems to work!

 

Only downfall I see here is the Zap will crash if it doesn’t find a matching record

 

--

Next step is to now extract the necessary data

christina.d
1 person likes this
  • christina.d
    christina.d
chanelle
Forum|alt.badge.img+8
  • chanelleZapier Staff
  • Zapier Staff
  • 628 replies
  • October 6, 2022

Hi @bedoya 👋🏾, 

I’m happy to hear you were able to get the Zap up and running! I see you noted that the Zap crashes if a matching record isn’t found. Is there a course of action you would like to take place if a record is not found? Maybe I can help!

christina.d
Forum|alt.badge.img+9
  • christina.dZapier Staff
  • Zapier Staff
  • 2653 replies
  • Answer
  • October 28, 2022

Hey there friends! I wanted to pop in and share some of the details from the support ticket.

Spoiler Alert: @Troy Tessalone nailed it.

It seems that Salesforce will only return a result if there is an EXACT match for the Account name provided….We also have a feature request to allow a fuzzy-type search (that should bring up "A. Duda & Sons, Inc." for "A. Duda & Sons, Inc")

 

Our Engineers constantly (re)prioritize open issues and the more votes we get for a feature, the better its chances are to get implemented sooner! There are multiple factors at play (such as the development effort needed or if we need to liaise with the partner in case their API needs changing, too), but as we have your vote recorded, you'll be among the first to know when this feature gets shipped! 

 

Since we’ve identified this as a feature request, we’ll also be sure to keep this topic updated here in community if and when this ships. 🙂

Thanks for raising this in community! 🧡

Terms & Conditions