Free mail merge google sheets

The power of mail merge!

There are a few ways to do a free mail merge in Google Sheets. Here are a few options:

Option 1: Using Google Sheets' built-in Mail Merge feature

Google Sheets has a built-in Mail Merge feature that allows you to merge data from a sheet with a template. Here's how to use it:

1. Create a new sheet with your data (e.g., names, addresses, etc.).
2. Create a template document (e.g., a Google Doc or a PDF) with placeholders for the data you want to merge.
3. Go to the "Tools" menu in Google Sheets and select "Mail Merge".
4. Select the sheet with your data and the template document.
5. Choose the fields you want to merge (e.g., name, address, etc.).
6. Click "Merge" to create a new document with the merged data.

Option 2: Using Google Apps Script

You can also use Google Apps Script to create a mail merge script that runs automatically. Here's an example script:

1. Open your Google Sheet and go to the "Tools" menu.
2. Select "Script editor".
3. Delete any existing code and paste the following script:

   
   function mailMerge() {
   var sheet = SpreadsheetApp.getActiveSheet();
   var dataRange = sheet.getDataRange();
   var data = dataRange.getValues();
   var template = "Your template document URL";
   var output = [];

for (var i = 0; i < data.length; i++) { var row = data[i]; var mergedData = []; for (var j = 0; j < row.length; j++) { mergedData.push(row[j]); } var mergedDoc = DocumentApp.openById(template).getBody(); mergedDoc.appendParagraph(mergedData.join("\n")); output.push(mergedDoc); }

return output; }

4. Replace "Your template document URL" with the URL of your template document.
5. Save the script and run it by clicking the "Run" button or pressing Ctrl+Enter.
6. The script will create a new document for each row in your data sheet, merging the data with the template.

**Option 3: Using a third-party add-on**

There are several third-party add-ons available that offer mail merge functionality in Google Sheets. Some popular options include:

* AutoCrat: A popular add-on that allows you to create custom documents and emails using a mail merge template.
* Merge: A simple add-on that allows you to merge data from a sheet with a template.
* DocRaptor: A powerful add-on that allows you to create custom documents and emails using a mail merge template.

All of these options are free, but some may have limitations or require a subscription for advanced features.