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.

New to Zapier so please bare with me. 

I have set a up a Zap from our CRM, when a stage in the process is updated, a new row with data from the CRM is added to Excel.

This worked in the test however is now not working when the stages are reached within the CRM.

Excel is only showing two lines of data, which are from when the tests were run. From the below example, the action should have been completed seven times therefore seven new lines added to excel. 

I have check the connection to the CRM and excel is correct. 

 

Note due to company policy, I cannot state the CRM system we use. 

 

 

 

 

Hi @BettyTester 

Good question.

It may be due to the trigger type.

Scheduled triggers can take from 1-15 minutes to fire depending on your Zapier plan.

https://help.zapier.com/hc/en-us/articles/8496244568589-Types-of-triggers-in-Zaps

Thank you for your reply.

The zap appear to be working fine with Zapier. The spreadsheet is not showing any new data even a day later. 

@BettyTester 

If the Zap is triggering, then check your Zap Runs to see the DATA IN/OUT for each Zap step to help you troubleshoot: https://zapier.com/app/history/

 

Otherwise, without seeing screenshots with how your Zap steps are configured we are limited in our ability to evaluate and advise.

Hi Troy, thank-you for your reply.  I have checked the in/out data which looks correct.

I’m limited to what I can show due to privacy of the data and i am very new to Zapier. Can you please advise what screen sections would help and I will try to send a copy. 

@BettyTester 

PII should be obfuscated but other info should be shown.

Screenshots with how the Zap steps are configured.

Screenshots with the Zap Runs DATA IN/OUT for each Zap step.

Unsure if these help as I have had to take out a lot of information

 

@BettyTester

Help articles about using Excel in Zaps to reference: https://zapier.com/apps/excel/help

 

This shows the row where the data was added. (Row 949774)

That means the Excel file has nearly 1 million rows!

 

WHY!!!!! oh, Why would it put it down there?????? I don’t even know how to hunt that far down. 

@BettyTester 

Excel files need to be configured in a certain way to be used in Zaps.

Help articles about using Excel in Zaps to reference: https://zapier.com/apps/excel/help

 

We recommend all your columns have text in the header/top row, but you must have text in the first column header, especially if you are using the Create Spreadsheet Row action. Without any text there, the Zap will send your data to the top of the sheet rather than to the bottom.

Reply


Terms & Conditions