Generate and email PDF invoices from Google Sheets with Orshot and Gmail

## Generate and email PDF invoices from Google Sheets For freelancers, agencies and small businesses who track invoices in a spreadsheet and want each one turned into a designed PDF and sent without copy and paste. ### How it works 1. Every 15 minutes the sheet is checked for invoices with Status set to Ready. 2. Line items are matched to each invoice by invoice number, then subtotal, tax and total are worked out. 3. Invoices with missing data are marked Error with the reason, so nothing half-filled goes out. 4. Orshot renders the invoice PDF from a template. 5. Gmail emails the PDF to the client and Google Drive keeps a copy. 6. The row is updated to Sent with the PDF and Drive links. ### Setup 1. Get an Orshot API key at https://orshot.com (the free plan includes 100 credits a month). 2. Add the invoice template (https://orshot.com/templates/2470) to your workspace and pick it in Render invoice PDF. 3. Make a sheet with an Invoices tab and a Line items tab (columns in the description) and pick them in the three Sheets steps. 4. Put your company name, address and payment details in Build invoice data. 5. Add Google Sheets, Gmail and Google Drive credentials, then set a row to Ready.