âïž Document / data merge in Google Sheetsâą, Google Docsâą & Google Slidesâą. âïž Also works with data in Microsoft Excel and CSV files. âïž Design your template in Google Docsâą or Google Slidesâą. âïž Generate documents in PDF, Google or Microsoft Office formats. âïž Email & share each file to specific people. đ Read more about pricing, quota, features, support,... đ Need support? Contact support@publigo.app and our team will get back to you shortly! Or visit our help center: https://www.publigo.app/help-center ââââââââââââââââââââââââââââââââ đ° QUOTA AND PRICING: †Freemium: first campaign 100% free, then free for up to 30 files/ campaign. †Plans start at $2.5 / month. †Monthly, yearly & lifetime plans available. †Team plans available for Google Workspace domains. https://pricing.publigo.app/ ââââââââââââââââââââââââââââââââ đ AVAILABLE IN GOOGLE SHEETSâą, DOCS & SLIDES †If you prefer to work from your database or create documents from selected rows, use Publigo in Google Sheetsâą. †If your list is inside a CSV or a Microsoft Excel file or if you donât have a database but want to make a copy of a template and replace specific info in the copy, open Publigo from Google Docsâą or Slides. ââââââââââââââââââââââââââââââââ đŻ 3-STEPS TUTORIAL: 1ïžâŁCreate a Google Docsâą (or reuse an existing Word file) and add merge tags like {{First name}} to customize each copy. 2ïžâŁ Prepare your data source in a Google Sheetsâą (or reuse an Excel or CSV file): add a column with data for each merge tag you added in your template. 3ïžâŁ Open Publigo from your spreadsheet and run your campaign: Publigo will make a copy of your template for each row of your spreadsheet (or only the selected ones) and replace markers by the data in each row. ââââââââââââââââââââââââââââââââ đ”ïž FEATURES †Generate thousands of documents in one click. Super fast. †Personalize each document thanks to merge fields / tags (if you want a different First Name to appear in each document, add {{First Name}} in your template, a âFirst Nameâ column in your database / spreadsheet and Publigo will automatically retrieve the names from this column, and merge them row by row into your documents). †Generate your documents as PDFs, Google files (Docs, Slides, Sheets), or Microsoft Office files (Word, PowerPoint, Excel). †Email any file generated: Personalize your email subject and content, add your PDFs or Microsoft files as email attachments. Send each file to a specific recipient or form respondent or all files to the same recipient. Add CC and BCC. Reuse Gmailâą aliases. †Google Forms: generate a new file for each form submission. †Zapier, Trello, etcâŠ: generate a new file when a row is added to your spreadsheet. †Select specific rows or use a spreadsheet filter to only generate files for specific rows (or just for one row). †Bundle all generated PDF or Word files into a single file for each sharing or printing (PDF merge). †Generate a test file to preview your work: Check your document formatting, links, images, etc. and make it look perfect. †Easily store each generated file in a target folder in Google Driveâą. †Schedule your file generation at a specific date to generate your file at your preferred date/time. †Share your generated files to your recipients and reuse Google Driveâą permissions: Editor, commenter or viewer. †Choose a naming convention for your documents with standard merge tags such as {{template name}}, {{form title}} and {{increment}} to easily differentiate your files. †Combine all rows into one file: super useful to print labels. †Use conditional merge options to highly customize your document with gender, formula, plural accord etc. †Regenerate files on a weekly, monthly or yearly basis (recurrence: especially useful when combined with spreadsheet formulas). ââââââââââââââââââââââââââââââââ đ€ Why use Publigo over Autocrat, Form Publisher, PerformFlow - Form Publisher & Approvals WorkFlow, Form Director, Document Studio or Portant? †Itâs 100% secure! We do not store any of your sensitive data, and we only ask for the minimum permissions necessary for Publigo to work. See our Privacy Policy for more details: https://www.publigo.app/privacy-policy †Itâs actively maintained and updated by passionate developers / Google Developers Expert †User-friendly and easy to use, no coding skills (like HTML/CSS) are required to generate files, allowing you to save time and focus on your objectives rather than the technical setup †Customer support is fully available to all users: Our team aims at providing you with the best experience possible using Publigo, so feel free to reach us at support@publigo.app whenever you need it! †The add-on has successfully passed the thorough security review from Google. Therefore, Publigo has been approved for publishing and presents no harm to our users. ââââââââââââââââââââââââââââââââ USE CASES Not convinced yet? Here are some examples of Publigo use cases: †Looking for a job? Personalize your CV / resume and cover letter for each company you are applying to and automatically send them by email in one go! (job application) †Use CSV files extracted from your CRM (Salesforce, HubSpot, Copper ...) to generate your files. †Send invoices for every purchase made in your store! †Send purchase orders to your suppliers. †Are you part of an association? Send tax and charitable donation receipts! †Generate personalized brochures / sales pitches for each of your clients / prospects. †Generate personalized and beautiful event invitations. †Easily prepare customized meeting notes for every meeting. †Greeting cards: Send Christmas, Happy New Year, Thanksgiving, vacation greetings, birth announcements, etc. to your friends, family, colleagues, association members... †Do you have incident report forms? Connect a template with Publigo to generate beautiful and printable reports automatically! †Want to hire someone? Generate job offers in bulk from a template to always keep the same branding. †Automate the generation of your financial reports or activity reports using a Spreadsheet template with formulas and charts. And much more! If you like Publigo, please support us by giving us a 5-star rate or leaving a short review on this page! You may also want to try our other apps like Mergo (https://www.mergo.app/) or Folgo (https://www.folgo.app/). Publigo was created by Romain Vialard, Scriptit. Romain is also the creator of Yet Another Mail Merge (YAMM), Awesome Table & Form Publisher. He is not involved in those products anymore (they are now maintained by Talarian). Romain is a member of the Google Developer Expert (GDE) program and has been working on Google Apps Script and Google APIs for more than 10 years.