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.

I have zaps set up to

  1. Create a new row on Google Sheets when a new opportunity is created on Salesforce
  2. Search for, and update, the relevant row on Google Sheets when an opportunity is updated on Salesforce

I would like to either update the zap(s) I have or create (a) new zap(s) to have the Google Sheet updated whenever a new Salesforce Product is added to an existing opportunity. However, I’m not sure which data value this is on Salesforce.

Hi @rachlee 

Good question.

Sounds like Products are linked to Opportunities in Salesforce.

Therefore, it’s like the linked Products would show as an array of items on the Opportunity data returned.

This array of items is likely going to be the internal Product IDs from Salesforce.

So, you’ll probably have to use a Salesforce Find Record step in the Zap to get more data points related to the Product.

 

The Looping app can be used to handle 1+ line items in an array: https://zapier.com/apps/looping/integrations

Terms & Conditions