Hello Zapier people!
I need some help if possible with Zapier!
I am trying to integrate a system with Google Docs.
The idea is to be able to make quotes from CRM directly into Google Docs. But currently I have a challenge with transfering products prices and details as a table.
In the CRM I have a table which looks like this:
Product 1 | Price 1 | Units 1 | Total 1 |
Product 2 | Price 2 | Units 2 | Total 2 |
Product 3 | Price 3 | Units 3 | Total 3 |
When Zapier pulls the data I receive the following:
Product Info: Product 1, Product 2, Product 3
Price Info: Price 1, Price 2,Price 3
Unit info: Units 1, Units 2, Units, 3
Total info: Total, 1, Total 2, Total 3
In order to make it into a table in Google docs I need to separate it back again, so I use formatter to split each parameter into separate values
So it will be
Formatter 1 - Split Products
Formatter 2 - Split Price
Formatter 3 - Split Units
Formatter 4 - Split Totals
Then in google docs I use variable parameters in order to make it into a table:
{{Product1}} | {{Price1}} | {{Units1}} | {{Total1}} |
{{Product2}} | {{Price2}} | {{Units2}} | {{Total2}} |
{{Product3}} | {{Price3}} | {{Units3}} | {{Total3}} |
The problem is that I need to use many Formatter steps since my columns are 10.
I am looking for a code step to replace the formatter steps and do everything in one go if possible.
I tried HTML for Google Docs but I cannot make it work, since it crates rows, and I actually need to create columns.
Thank you for your help!
Ivan