Hi, everyone I am fairly new to Zapier and I am still overwhelmed by the number of options. What I am trying to do is take data from Invoice ninja, edit that data and add it to my spreadsheet in the appropriate columns. I am guessing i need two zaps.
The data that I can get out of invoice ninja looks something like this:
Name of product
Duration: 9 Hours;
Date: 5 Aug 2022;
Start Time: TBC;
Start Location: TBC by guests.
That’s all in one section. How can I get this to split up so I can then add it to my google sheets, so that “Name of product” goes in the correct column, date in another but without “date:” just 5 Aug 2022, Start time in another (again without “start time”) and same for start location.
I hope this makes sense and someone can help me with this! I don’t know if there is an integration that can do this, or if it would require custom code.
Thanks so much!
Best answer by TamRazzleDazzleView original