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 a unique situation where I have multiple (measured in 10’s to 100’s) of users that need to update multiple destinations with new data. This data is gathered ad hoc and can land in a Google Sheet when collected. I need to get that data OUT of the Google Sheet and INTO several software applications for each individual.

 

Example:

User A & User B have new contacts. They enter the details into Google Sheet (source). This Source data needs to be added to:

CRM (Zapier enabled)

Email Marketing Company (Zapier enabled)

Ad Target Lists (Zapier enabled)

 

and assigned to the relevant user.

 

I can add a column in Google sheets to pass a variable (username, etc) to key against. My thought is that Zapier would parse each new spreadsheet row, identify the user, and run a zap built FOR THAT USER that has all of the downstream API, Login, etc info. 

 

Is this a thing? 

Hi @kennethjamaca 

Yes, that’s the power of dynamically mapping data points between Zap steps.

Please reference this article about Zap action steps: https://zapier.com/help/create/basics/set-up-your-zap-action

FYI: App APIs can be used via Webhook action steps in Zaps: https://zapier.com/apps/webhook/integrations#triggers-and-actions

FANTASTIC! Follow up question… who can I hire to set this up for me? :grin::sunglasses:

@kennethjamaca

Check out Zapier Experts: https://zapier.com/experts

TIP: Put together documented project requirements (e.g. in a GDoc) that can be shared for review by whomever you are trying to hire for the job.

****SOLVED****

 

So, the best answer to my question was answered directly by a Zapier Expert (David Mercer from Mercology). He informed me of the Zapier Filter Action. This allows me to filter out the primary key (email address) and run a distinct zap for each user. Filter saved my sanity.

Terms & Conditions