Google Sheets Auto-create

You can use auto-create in Google Sheets source workflows to create automated workflows. These workflows can be triggered when a new row is added, or when data in a row is changed. In this guide we will show you how to:

1. Turn on Auto-create
2. How often does Auto-create run?
3. Auto-create when data in a row changes (✨ Pro feature)
4. Auto-create when a specific value changes e.g. Status (✨ Pro feature)

Turn on Auto-create

When you have created a workflow with Google Sheets as the source, you can turn on Auto-create in the top right corner. When you turn on Auto-create you will see the following options:

When you tun on Auto-create an Auto-create status will always be displayed in the top right corner here:

When Auto create is turned on, it will process any new rows of data added to the bottom of the spreadsheet table from the point in time it is turned on.

Note | Auto-create does not process any rows of data already stored in the spreadsheet. Only new rows of data added to the bottom of the spreadsheet will be processed

How Auto-create works

When Auto-create is turned on, Portant counts how many rows of data are in the spreadsheet. Then when Auto-create is ON, and a row of data is added after the last row it will be processed by the workflow automatically.

If you want to have a spreadsheet with a formula in one of the columns we recommend wrapping the formula in an IF Statement, to display nothing if there is nothing in the row, like this:
=IF(A17="","",(**Your Formula**))

‍
If you don't do this then Portant will only process rows added below the the last row with a formula in it. For example:

How often does Auto-create run?

If you are on the Free plan, Auto-create runs every 10 minutes. However, if you want it to process more frequently you can upgrade to our Pro or Team tiers and Auto-create will run every 2 minutes.

• Every 10 minutes - Free plans
• Every 2 minutes - Pro & Teams Plans

Auto-create when row data changes (✨ Pro feature)

Sometimes you might want to run auto-create when data in a row changes. Portant has a Pro feature that takes a snapshot of the data in your spreadsheet at the time it's turned on. Then whenever a change in the data is detected, Auto-create will process the row with changed data. To turn on this feature, you can select the check box in the Automation panel here:

Auto-create when a specific value changes e.g. Status (✨ Pro feature)

You can combine this feature with a workflow filter that enables you to only processes rows when a status is true. For example you could have a status in a Spreadsheet that is either 'Draft' or 'Send'. Then when you want to process the row of data, you change the status to 'Send' like this:

To build this, you would turn on Auto-create when a specific value changes and then add a workflow filter to only process data when the 'Status' is 'Send'

This can also be a great solution to prevent partially completed rows to be processes by Auto-create.

Feedback and feature suggestions

We created Portant in 2021 and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback please feel free to send us an email at contact@portant.co or use our contact form here: https://www.portant.co/support

Thanks,

Blake and James

‍