Automatically generate a document when a row is populated

Publigo's "For each new row" feature generates a file when a blank line is filled in your campaign sheet. Publigo operates in the background checking your campaign sheet every hour and generates a file if it sees newly filled rows.

Set up using Google Sheets (for manual entries)

1. Build your campaign sheet & your template first

2. In your Publigo sidebar, click the Spreadsheet menu

3. Click More actions > Schedule merge > Select For each new row (Zapier).

4. You will now see a confirmation that: A new file will be generated if a row is added to the sheet.

5. It's time to test our configuration. Manually enter your campaign record(s).

Publigo will check your campaign sheet every hour and generate a document if it sees any newly filled lines.

You can manually enter your records (or copy and paste them) daily, weekly, monthly or as infrequently as you like. Publigo's "For Every New Row" feature runs continuously in the background and checks your campaign record every hour. It generates a document if it sees newly filled rows.

Set up with Zapier or IFTTT

In this section, you will create a workflow that will create a new record row in Google Sheets for each event created in Google Calendar. Publigo will then process this new event and generate a document or documents.

1. Configure your preferred automation tool (like Zapier or IFTTT).

This will create a new Google Sheets file for all your calendar events (this will serve as your campaign sheet).

2. Open the Google Sheets file created by Zapier or IFTTT, then follow our tutorial on how to set up your datasource.

3. Create your template and insert the relevant {{markers}} based on the header labels generated by the automation tool.

4. In your Publigo sidebar, click the Spreadsheet menu.

5. Click More actions > Schedule merge > Select For each new row (Zapier).

6. You will now see a confirmation that: A new file will be generated if a row is added to the sheet.

Test your workflow

It's now time to test your Zapier or IFTTT workflow.

1. Create an event in your Google Calendar.

Add guests as needed (we have 1 guest in this example) and a location.

Once you click the Save button, your automated workflow will instruct Zapier or IFTTT to send the calendar event details to the linked Google Sheets file.

2. In a few minutes, your Google Sheets file will be populated with the newly created calendar event.

3. Publigo’s For each new row feature will always be running in the background checking your campaign sheet every hour and will generate your files if it sees newly populated rows.