[New Integration] Advanced Utilities

Userlevel 7
Badge +12

Hey everyone,

I would like to share a custom Zapier integration I built to solve a few problems. The integration provides the following action steps. I hope you find it helpful. :)


Run JavaScript Code: This is kind of a clone of the regular Code Step. Nothing fancy, it just comes with some useful tools available in the global scope. It also supports modern JavaScript async/await.

The global scope includes the following utilities:

  • moment: The well-known moment.js library that helps when dealing with date/time.
  • _: Lodash library that makes it easier to work with objects and arrays.
  • JSON: this replaces the built-in JSON.parse function with the more advanced JSON5 library.
  • toCSV: A function that converts an object to CSV.



Export to CSV: This action makes it easy to convert JSON data or line items to a CSV string or file.



If you’re interested in trying it, here’s the invite link: https://zapier.com/developer/public-invite/112461/039174f595539444ce5c14e114c1dc1e/


Known issues:

  • The code field in Run JavaScript Code action doesn’t highlight code.

Feel free to report any other issues and let me know if you there’s any other library that you wish you could use in a Code Step.

35 replies

Userlevel 1

Awesome work @ikbelkirasan

Userlevel 1

Hi @ikbelkirasan!

Got a question, maybe you can help.

I use “Export to CSV” and “Input Type: Line Items”. I have around 50 line items and get a 400 error when testing with data that contains danish characters (æ,ø,å) in keys and values. Can you imagine a way I can get through with this? 

Weirdly, if I test with just a few line items containing danish characters, I get no errors. 


This tool is great, thank you so much!

Is it possible to rename the file being generated?  Currently it’s coming through as “output.csv” but ideally, I’d like this filename to be unique and contain the current day’s date.

Userlevel 1

Thanks for creating this brilliant tool @ikbelkirasan!

Userlevel 1

Hi @ikbelkirasan -  I accepted in the invite using the link (https://zapier.com/developer/public-invite/112461/039174f595539444ce5c14e114c1dc1e/), but I’m still not able to build the zap / access the “Advanced Utilities” options. Is there maybe a new(er) invite link I should be using? Thank you so much! 😀

Userlevel 7
Badge +12

Hi @qbftech - The link still works. Maybe you need to refresh your zap editor page to access the integration. Make sure to select it in an action step.

Hi @qbftech - The link still works. Maybe you need to refresh your zap editor page to access the integration. Make sure to select it in an action step.

I with the same Problem, maybe something is wrong

Userlevel 7
Badge +9

Hey there, I gave this a shot and the invite it still live, @Yago Almeida!

You’ll need to accept the invite and perhaps give it a minute and/or do a hard refresh of the editor. It’s worth mentioning this app will only be visible as an action step.

I hope some of this helps! 🧡

Hi, @ikbelkirasan!   I am new to Zapier and trying to convert a JSON file on my google drive to a CSV file and found your integration.  Yet when I select the file name [File: (exists but not shown)] for the ‘*JSON data’ field from the previous google drive step and test it, I keep getting:  JSON5: invalid character 'h' at 1:1.  Am I not able to pull a file in from my google drive or do I need a URL of where the file is?  Thanks for any guidance.

Thanks @ikbelkirasan this is soooo useful!

I think the CSV export utility skips over empty line items in the input which is sub-optimal because it leads to variability in the number of columns, and the column order. Is there any way you could add an option to preserve empty columns?