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.

Hey! I have a Gravity Form that contains line item data, and I’m trying to add each line item to its own row in an Excel spreadsheet. I can’t figure out how I need to format the data to make it appear on individual rows - everything I’ve tried thus far sticks all my data in one cell.

The data from Gravity Forms comes in as: 

  • Input1: data1, data2, data3
  • Input2: dataA, dataB, dataC

Here’s what I’ve tried with Formatter:

  • Text: Split Text - the separator being “,” and having the output be both line items and separate fields
    • It didn’t matter if the output was “data1, data2, data2” or a“data1”], d‘”data2”], [“data3”]… it would still place everything in one cell instead of splitting it up into rows in Excel
  • Utilities: Line Itemizer - when running this, the Data Out was correct -
    • 0:
      • Test: data1
      • Test2: dataA
    • 1:
      • Test: data2
      • Test2: dataB
    • etc…
  • But when I try to add that to Excel, the only output it allows me to select is how the data went in… formatted back to “data1, data2, data3”

I’m at a loss of what else to try. Thoughts?

Try GSheets instead

 

@Troy Tessalone  Unfortunately, I can’t use GSheets. The data coming in needs to be stored securely on my company’s OneDrive account, and GSheets doesn’t live up to the security standards our IT department requires.

Adding an update: I’ve now tried a webhook, and I’m still running into the same problem - it’s dumping all my data into one cell.

Might have to use create a looping Zap that takes each line item and adds it as a new row in Excel

I didn’t know you could create a looping Zap. How would I implement that?

It involves webhooks, filter, and code.

Message me directly if you’d like me to configure this for you.

For anyone needing an answer for this… this worked like a charm: 

 

Terms & Conditions