Google Sheets to Agrello

Google spreadsheet Row will create a new document with filled in data

Before you start

Make sure you have all the necessary files to work with:

Spreadsheet prepared (with header similar to variables in your contract)
A Word (DOCX) document with variables is created (example files here) and uploaded to Agrello as a template.

Step 1

Prepare your Google Sheet with table columns providing the data you want to be added to the document in Agrello.

Step 2.

Create a Word file and upload it to Agrello as a template.

Setting up Google Spreadsheet trigger

Step 1.

Choose Google Spreadsheets from App selection

Step 2.

Select Trigger (New Spreadsheet Row)

Step 3.

Connect Google Account

Step 4.

Select Spreadsheet file to work with

NB! Create at least one line in the table after header so Zapier tests can work. Also note if you have e-mail field its better to fill in with test data at first also.

Step 5.

Test new row creation

Setting up Agrello action

Step 1.

Choose Agrello app as an action

Step 2.

Select Event (Create New Document From a Template)

Step 3.

Connect Agrello account

Step 4.

Configure the action.

Start by selecting the template you previously uploaded.

Based on the fields in the template the additional configuration fields are displayed. In this example you can add Agreement Start Date, Party A full name, address etc.

Step 5.

Once you have completed the configuration you need to test Zapier flow.

If the test is successful you should see the new document created in Agrello, using the template file you chose filled with the data from your spreadsheet.