How do I convert data from csv (that comes through via email) into Google doc table format? I am using “create doc from a template “ feature, however, I am having formatting issues
Step 1: Find File from Gmail (works)
Step 2: Converting attachment into cvs using “Utilities” Formatter (works)
I want to create a table (with exact same information in the csv) into a Google doc but coming across formatting challenges (Not working)
What Do I Need in a Table of Google Doc (Final Output)
Product Name. Qnty
Product 1 10
Product 2 15
Product 3 20
What I am actually getting post using Formatter
Product Name: Product 1,Product 2,Product 3
Qnty: 10,15,20
Best answer by jesse
Hey @charlesriver! Summarizing some of the suggestions here for anyone following along that has a similar question.
If you want to create a table in a Google Doc, Troy is correct that the you can do this using HTML and that the Zap action you need for that would be Google Docs Create Doc from text:
Sometimes a good option when you want to use line items in different steps of the Zap, Looping may be another thing to explore: https://zapier.com/apps/looping/help. I’m not sure if that would work in this case because you need you need each line to go into one Create Doc from text step, you can’t add each line item one at a time.
That should get you pointed in the right direction but as always, feel free to come back to this thread with more details on your setup/workflow and we can keep digging into this!
Quick Question - In the above HTML example, the cell data are pre-populated in the code. How would I link that in my HTML code if my data is coming from a google sheet or csv? Like one sheet would have 5 rows while the next time it could be 8 rows with different information. What is the best way to input that via Zapier?
Might be better if you were to provide a screenshot with the desired output for us to have context about what you are trying to achieve with the layout/format/structure of the data points.
Hey @charlesriver! Summarizing some of the suggestions here for anyone following along that has a similar question.
If you want to create a table in a Google Doc, Troy is correct that the you can do this using HTML and that the Zap action you need for that would be Google Docs Create Doc from text:
Sometimes a good option when you want to use line items in different steps of the Zap, Looping may be another thing to explore: https://zapier.com/apps/looping/help. I’m not sure if that would work in this case because you need you need each line to go into one Create Doc from text step, you can’t add each line item one at a time.
That should get you pointed in the right direction but as always, feel free to come back to this thread with more details on your setup/workflow and we can keep digging into this!