Formatting a google sheet that was dynamically created by Integromat with Airtable Data

[YourFriend]

I have Integromat automatically generate invoices vai Google Sheets using data from AirTable.

Although after the invoice is generated it is fairly ugly given there is no formatting on the Google Sheet.

These invoices are dynamic so I cannot use a static template that I format in advance.

Is there a way to have integromat/airtable format the dynamically created google sheet?

Thank You, Friends.

[ScottWorld]

If you can figure out the Google Sheets API, you can update your cells with formatting by making API calls from Integromat.

Otherwise, I would suggest looking into DocuMint, which is a great document generation tool that can create formatted invoices from Airtable:

Documint

Documint - Document automation for productive people

Documint empowers businesses and individuals to automate everyday tasks using document generation to increase productivity.

[YourFriend]

Thank you, Scott.

You are a wizard.

I’ll look into the API method with Google Sheets.

Best Wishes

Wil IV

[Hannah_Wiginton]

Hey there!

This is exactly what the Google Sheets Document function in the On2Air Actions app does.

You can create dynamic templates based on your Airtable data plus you can create dynamic formatting inside Sheets so your data fits exactly how you need.

Function - Google Sheets Create/Export

On2Air | Accomplish Anything with Airtable – 8 May 21

On2Air: Actions | On2Air

On2Air: Actions is an Airtable automation and workflow tool to integrate and connect your Airtable data with any other software tools used in your business. Create powerful business processes with almost 20 additional action options beyond the...

[BenFortunato]

Was wondering if you were able to make any head way on this. We are looking to do the same, format the google sheet dynamically. Documint works for invoices, but this are more dynamicaly created spreadsheets that will be editied by users. Documint doesn;t offer that functionality.