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 data table named “products” in glide. It has multiple columns and multiple rows. First row has headers as names for each column. Via API i’m able to pull the data from glide’s table to zapier’s ‘glide’ step. Now i just need to convert this into a table format exactly how it was in glide tables i.e. either as a csv, xlsx or google spread sheet. Then this file needs to mailed to a specific gmail account every sunday. 

I’ve set up the schedule triggered step. Then i have the glide step with the API connection in place which is able to get the data from the table. i’ve tested uptil this point and data is being captured. But thats it. 

I’m stuck here.
How do i convert this data that is present in the glide step, back to a table format with the headers intact and in the same order as it is in the original glide tables? AI says use formatter but i can’t seem to understand how?

Also will there be any limits to how many rows of data it can process while making the csv/xlsx/google sheet ?

Please help!

Hey ​@Ruak,

I think you probably have to Code by Zapier action or use Google Sheets as an intermediary. See more about Code by Zapier here- https://zapier.com/blog/code-by-zapier-guide/. Hope it helps!

Hi ​@Ruak, just checking in to see how things are going. Did Sparsh's suggestion help you get the Glide data converted into a CSV file format? 

Let us know if you were able to get it working, or if you're still running into any trouble - want to make sure this gets sorted! 🙂

​@SamB Unfortunately no. I’m new to Zapier and the reason i selected it was because its primarily no-code. I’m unable to use the formatter to get my data in the proper format. Currently i am able to pull the data successfully from glide tables, make a csv and e-mail it to my address but ALL THE DATA is in the first row of the spreadsheet separated with commas(due to csv obviously). 

Hello @Ruak,

I am happy to help if you’d like. I would just need to know how the data is coming into the zap.

The free version of Glide doesn’t allow Zapier integration, so I couldn’t mock anything up for you.

If you’re getting line items then a loop with a formatter to add the newline character at the end of a row may solve the issue of it all being on one line. 

Badger

Hey ​@Ruak,

You can use some of the inbuilt Formatting from Formatter → Utilities action but if it’s insufficient for you, you may have to use Code by Zapier. Alternatively, you can AI by Zapier Analyse and return action if it can give you the desired output. 
 

As you said you are trying to use API to fetch data that’s why more advanced formatting is required. Hope it helps!

PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn

​@SamB Unfortunately no. I’m new to Zapier and the reason i selected it was because its primarily no-code. I’m unable to use the formatter to get my data in the proper format. Currently i am able to pull the data successfully from glide tables, make a csv and e-mail it to my address but ALL THE DATA is in the first row of the spreadsheet separated with commas(due to csv obviously). 

Sorry to hear that ​@Ruak. Looks like Badger and Sparsh have since suggested some other approaches that might do the trick. If they don’t work or you get stuck, can you share some screenshots here showing the output of the Glide action as well as the Configuration section of the rest of the actions in the Zap? That’ll help to give us a bit more context so we can better determine how to fix it. Be sure to remove any personal info like names, emails etc. before sharing as this is a public space (you can use a tool like Zappy for that).

Looking forward to hearing from you!

Terms & ConditionsAccessibility statement