AutoMerge For Google Spreadsheets
Auto Merge Ultimate Mail Merge Solution for Google Sheets and Gmail
Transform your Google Spreadsheet into a powerful, automated communication engine. Automerge for Google Spreadsheets is a seamless and intuitive add-on designed to simplify and supercharge your mass email campaigns directly from your data. Whether you’re sending personalized newsletters, customer updates, or critical business documents, Automerge streamlines the entire process, saving you time and ensuring every message is personal.
How It Works:
Prepare Your Sheet: Ensure your Google Spreadsheet has the data you want to merge.
Draft Your Email: Create a draft in Gmail with your desired template and use
{{header}}placeholders.Run Automerge: Select your draft and run the tool. AUtomerge will handle the rest, personalizing each email and sending it with the correct attachments and delay.
Effortless Mail Merging: Just like traditional mail merge, AUtomerge uses your existing Google Spreadsheet as its data source. It intelligently identifies and uses your current headers and data, allowing you to leverage your existing sheets without any tedious reformatting.
Smart Column Management: Upon activation, AUtomerge automatically adds two essential columns to your sheet: one for the recipient’s email address and another to track the sending status of each email. This provides a clear, real-time overview of your campaign’s progress.
Gmail Draft Integration: Forget complicated email editors. AUtomerge leverages the power and familiarity of Gmail Drafts. Use a draft as your email template, complete with your desired formatting, images, and attachments. Simply insert placeholders like {{header_name}} and AUtomerge will automatically replace them with the corresponding data from each row in your spreadsheet.
Throttle Control for Safe Sending: Avoid email throttling and ensure delivery by controlling the sending interval. AUtomerge offers customizable delays between emails (1, 2, 5, 10, or 20 seconds), allowing you to send large volumes of mail safely and reliably.
Dynamic Document and PDF Generation:
Go beyond simple emails. AUtomerge can generate personalized PDF documents on the fly. Using a Google Doc as a template, you can dynamically create unique documents for each recipient, such as appraisal letters. These documents are then automatically attached to the email and a copy is saved to your Google Drive for future reference.
Personalized Attachments: Send custom, data-driven attachments to each recipient. Whether it’s a personalized appraisal letter, an invoice, or a report, AUtomerge ensures every attachment is tailored to the individual, creating a professional and polished experience.