Contact support@publigo.app if you need support or have a question on our product!

*** What is Publigo? ***
Publigo is a 100% free document merge tool for Google Sheets that lets you:
Generate documents in bulk via a template filled with data from your spreadsheet: use a template with merge tags to create  document for each row in your sheet
Turn Google Form submissions into PDFs, Google files or Microsoft files: for every form submission, the data are collected and used to create a document
Schedule your merge documents at a specific date and time: specify a date for each row and your documents will be automatically generated

Easily generate documents with those simple steps:
1. Create a template document either from Google Docs, Sheets or Slides and add merge fields like {{First Name}}, {{Date}} etc.
2. List those same fields (First Name, Date ...) as columns headers in a Google spreadsheet and fill it with the relevant data.
3. Open Publigo from the "quick access" right side panel of your Google Sheets, and select your template. Optionally, you can also choose your target folder where your new files will be stored.
4. Launch Publigo, and that’s it! The add-on will automatically generate all your files as PDFs, Google files (Sheets, Slides, Docs) or as Microsoft files (Excel, PowerPoint, Word).

Publigo also comes with a powerful feature that lets you automate file generation from Google Forms submissions. Each time a respondent submits a Google Form, Publigo will convert the form responses into various types of documents (PDFs, Google Docs, Google Sheets, Google Slides, Microsoft Excel, Microsoft Word, or Microsoft PowerPoint) from a template that you have previously selected from Google Drive. This allows you to present your Google Forms’ data in a more impactful and suitable format, making your data meaningful.

With Publigo, schedule your merge documents by specifying the date in your sheet. Then, Publigo will generate the document for each row when the date specified in the sheet will be reached!

Optionally, you can also send those generated files by email as attachments to a list of recipients, to the form respondent, and/or share the documents in Google format (Docs, Sheets or Slides) with editing, commenting or viewing access.

*** Publigo’s key features ***
➤ Document merge: Automatically mass generate documents in multiple formats (PDFs, Google Docs, Sheets, Slides, or Microsoft Word, Excel, PowerPoint) from spreadsheet data
➤ Generate files from Google Forms submissions, allowing you to present your form’s data in a more suitable way
➤ Personalize document templates from Google Docs, Sheets or Slides to create perfectly formatted files
➤ Easily store your generate files in a target folder in Google Drive
➤ Choose a naming convention for your documents with standard merge tags such as {{template name}}, {{form title}} and {{increment}} to easily retrieve your files
➤ Email management: Personalize your email subject and content, and add your PDFs or Microsoft files as email attachments. Send your email to your recipient list from your data spreadsheet, to form respondents or manually enter specific recipients. 
➤ Share your generated Google documents to your recipients and manage user permissions: Editor, commenter or viewer.

*** Publigo’s use cases ***
With Publigo, it’s very easy to generate any type of documents that best suit your needs: Invoices, purchase orders & sales quotes, brochures, project proposals, purchase requests, meeting notes, incident report forms, onboarding notes, lesson plans, job offer letters, resumes, financial reports, business reports, time off requests, registration forms and much more!

*** Why use Publigo? ***
Publigo is the first app from the latest generation of add-ons that offers you both document merge from Google Sheets and files generation from Google Forms submission features within one single tool. It is also 100% FREE and there's NO LIMIT on the number of files generated (except the technical limitations from the Google Apps Script API which are enough even for heavy users).
For $0, Publigo is a complete alternative to other add-ons like Autocrat, Form Publisher, PerformFlow - Form Publisher & Approvals WorkFlow, Form Director and Document Studio.
Publigo has been created by Google Developer Experts, which means that it is regularly maintained and updated to provide you the best experience possible. In case there are any issues, we’ll do our best to fix them in a timely manner.
We are also open to any new suggestions for improvements - if you want to submit a request, it’s as easy as that! Simply send us an email at support@publigo.app and we will shortly come back to you.

*** Is Publigo safe to use? ***
➤ Publigo is part of the next generation of add-ons for Google Sheets, using the latest and most secure Apps Script technologies.
➤ 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.
➤ Your data is 100% safe as we do not transfer or sell any personal data. We never save the content of your template, generated documents, Google Sheets and Google Forms’ data.
➤ We only store the minimum information that is absolutely necessary to perform the service you are requesting from our app. We are using Firebase to store those data, a serverless database provided by Google. Firebase database is stored and secured on Google Cloud, and it is ISO and SOC compliant. Data is also encrypted in transit and at rest. Please see our Privacy Policy for more details: https://www.publigo.app/privacy-policy
➤ Specific teams like the Development and the Support teams do have access to the database or part of the database, and they all signed and committed to our Information Security Policy, our Incident Response Policy, our Ethics Policy. Those policies are available upon request. Please send an email to support@publigo.app and we’ll send you a copy of those policies.

***********************************************************************************************************************

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 created Awesome Gapps, the company maintaining those products, but he is not involved in it anymore.
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.