Use this Lido automation to create price quotes in Google Docs automatically when a new row is added to a Google Sheet, then email the newly created price quote to a list of team members.
This automation fills a price quote Google Doc template with dynamic fields from a Google Sheet. A new price quote Google Doc is created for each new Google Sheets row.
Connect your Google Sheet to Lido with one-click. This automation will run each time a new row is added to your Google Sheet.
Use Lido's CREATEGOOGLEDOC formula to merge your sheets data into a pre-made price quote Google Doc template.
CREATEGOOGLEDOC(<Google drive credential>,<path to template>,<file name>,<output cell>)
Automatically email the newly created price quote Google Doc to your internal team members.
=SENDGMAIL(<sender-credential>, <recipient-list>, "New price quote", "Please find the new quote attached", <attachment url>)
The list of team members can optionally be maintained in a Google Sheet and passed through the <recipient-list> argument in the formula as an array.