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.

We are connecting Active Campaign to Smartsheet to automate the collection of our CRM data.  We used Add a New Row To Sheet in Smartsheet.  Each row contains the information on a single contact.  As our sales people add answers to each question Zapier records each individual response at the cell, not the row level.  As a result, for 1 contact it's creating 30 rows (Number of personal data q's being asked).  Is there another, better way to collect this information?  Can we schedule Zaps between Active Campaign and Smartsheet?  Any help would be much appreciated.  Thank you.

Yes, both of those apps integrate well with Zapier.

 

I am confused about where the information is coming from… Just so I understand a bit more, you are adding contact information to Smartsheets and want to create a contact in ActiveCampaign? Or is it the reverse, and your sales people are editing/creating contact records in ActiveCampaign and would like the information populated on a Smartsheet? 

If you can share screenshots of your set up that is also helpful. 

Thanks for responding.  Yes we are trying to port information from AC to SS.  

I can’t show much more of the Zap editor as the row contains a contacts personal info.  

 

Thanks.

 

 

It is set up looks something similar to the above? Which results in a row being added like so

 

Hah!

That’s where we are trying to get to.  The Zap is pulling the information we need.  The issue is it’s creating a row for every cell that has data added.

Each prospect has roughly 30 data cells with their info in them.  As each cell is filled out Zapier adds another row so instead of having 1 row with 30 cells of populated data, you have 30 rows and it’s the 30th row that has every answer the others contain 1-29!  My sense is Zapier is polling too frequently? We’d ideally like to run this once a day but there doesn’t seem to be an option to schedule between AC and SS.

Thanks so much for helping out with this.

 

Ahhh, I think I understand. It sounds like because Zapier is triggering on New or Updated that it is triggering each time a sales person fills out any deal field. So, since you have 30 deal fields it might be triggering 30 times. 

 

I would recommend setting up a filter so that Zapier only lets the data through when the 30th field is populated (or even all/most fields are populated). I just put in a random field from my test data but this sounds like it would help!

 

Awesome.  Maybe not currently, but we could make it so, to have this work correctly.

Final Q: what version of Zapier are you on.  We’re trialing so they say we are getting professional.  But I’ve never seen the condition ‘only continue if’.  I wonder if the issue is we’re not getting all the options as yet?  Of course, if they had human salespeople I could ask them directly if we are limited to certain conditions while using a trial version!

Again, thanks so much we will give this a shot.

Cheers

ahh, sorry about that, you’ll need to add a step in between AC and SS called “Filter by Zapier”

Terms & Conditions