You can automate documents creation using Google Sheets, Documentero & Zapier.
Tutorial for converting Google Sheet Rows into Documents (docx or pdf) Using Zapier & Documentero.com App for document automation
Step 1: Create Document Template
You can start creating your document templates in any editor (Microsoft Word / LibreOffice ) or using online tools (Google Docs) that supports docx format. You need to replace all fields that you are expecting to fill automatically with special tags sourrended by special “curly” brackets.
How to create document templates
Step 2: Upload your document template to Document Automation Service
Upload your document template into Document Automation Service. It will verify if it does not contain errors and list down all detected fields.
Step 3: Decide on document output format
Decide if you want to generate docx. (Word) or PDF documents as output. It’s better generate docx if you are going to edit them further.
Step 4: Connect your Zapier Account to Documentero account
You need to copy Documentero apiKey from your account page (click on user avatar > your account) to Zapier.
Step 5: Create new Zap in Zapier
Select Google Sheets - “New Spreadsheet Row” as Zap Trigger
Create your automation workflow and use Documentero as action to generate documents:
Zapier Documentero Integration
Select one of two actions:
- Generate Document (Generate Word or PDF Document based on Document Template)
- Generate Document and send as email attachment (Generate Word or PDF Document based on Document Template and sends it to the specified email as an attachment)
Select your document template (previously created in Documentero) & map all fields that you want fill in in document from your zap trigger.
Step 6: Test your workflow
Check if whole zap is passing through and generate documents for your needs.
Check More Video Tutorials for Zapier & Documentero integrations:
