Is there an actual free mail merge addon for docs

The eternal quest for free mail merge add-ons!

Unfortunately, there isn't a completely free mail merge add-on for Google Docs that offers all the features you'd typically find in a paid solution. However, I can suggest a few options that might help you achieve your goal:

  1. Google Docs Add-ons: While there isn't a free, full-featured mail merge add-on, you can try the following add-ons that offer some mail merge functionality:
    • Mail Merge (free, but limited): This add-on allows you to merge data from a Google Sheets spreadsheet into a Google Doc. It's a good starting point, but it has limitations.
    • Docxpresso (free trial, then paid): This add-on offers more advanced mail merge features, including conditional formatting and data validation. The free trial is limited to 10 documents, after which you'll need to upgrade to a paid plan.
  2. Google Sheets Add-ons: You can also use Google Sheets add-ons to merge data and then copy-paste the results into a Google Doc. Here are a few options:
    • AutoCrat (free): This add-on allows you to merge data from a Google Sheets spreadsheet into a Google Doc. It's a great option if you need to create simple documents.
    • Sheet2Doc (free): This add-on converts Google Sheets data into a Google Doc. It's a good option if you need to create documents with basic formatting.
  3. Workarounds: If you can't find a suitable add-on, you can try using Google Sheets formulas and formatting to create a mail merge-like experience. For example, you can use the QUERY function to merge data from multiple sheets and then use formatting to create a document-like layout.

Keep in mind that these options might not offer the same level of functionality as a paid mail merge solution. However, they can help you achieve your goal with some creativity and experimentation.

If you're willing to pay for a mail merge solution, there are many excellent options available, such as DocRaptor, MergePDF, and others.