Skip to main content

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

Hi @IvanStaykov 

Good question.

1 Code step can be used to replace multiple Formatter steps.

That will require knowledge of JavaScript or Python to handle array items and transform the data.


I tried this code:

 

It runs successfully but returns only the first set of items.

In the input I have 3 sets.

 

I cannot understand what i am missing.