Guides for Google Sheets
Short how-to guides. Each one shows how to make files from the rows of a sheet.
Generate invoices from Google Sheets, one PDF per client
Keep your invoices in a Google Sheet, one row each. Fill a Google Docs invoice from each row. Save it as a PDF, and email it to the client.
Google Docs template from a spreadsheet: merge tags that work
Write merge tags in a Google Docs or Slides template. Each tag fills from the right column of your sheet. Try the tag checker.
Google Forms to PDF automatically, one PDF for each answer
Turn each new Google Forms answer into its own PDF, from your own template. Fillmore can also email the PDF to the person who sent the form.
Google Sheets mail merge with Apps Script, or with an add-on?
Should you write your own Apps Script for a mail merge, or use an add-on? An honest look at the cost, the limits and the work each one takes.
Mail merge email limit per day in Google Sheets
How many emails can a mail merge from Google Sheets send each day? See the free Gmail and Workspace limits, and plan your list.
Mail merge only new rows in Google Sheets, and skip done rows
Run a mail merge again and again from the same Google Sheet. Only new or changed rows get a file or an email. Done rows are skipped.
Personalised letters from Google Sheets, with the right dates
Write one letter in Google Docs and fill it from each row of a sheet. Get dates, money and greetings right, then print or email each letter.
Google Sheets to PDF, one PDF for each row
Make a separate PDF for every row of a Google Sheet. Use it for invoices, letters or reports. Each PDF gets its own name in your Drive folder.
How to mail merge in Google Sheets
Turn each row of a Google Sheet into its own Google Doc. Make a template with tags, then fill it once for every row. No code needed.
How to make certificates from a Google Sheet
Make a certificate for every student or member from one Google Sheet. Design it once in Docs or Slides, then make one PDF for each row.
How to make Google Slides from spreadsheet data
Make one Google Slides file for each row of a spreadsheet. Design the slides once with tags, and fill them from your Google Sheet.
Send personalised emails with attachments from Google Sheets
Email each person their own PDF from a Google Sheet. Fill the subject and text from each row. Attach the file made from that row.