Portant Docs
Launch PortantInstall App in Hubspot ↗︎
Portant Docs
Portant Docs
  • 👋Welcome
  • 🟢Product Updates
  • 🌱Getting Started
    • How to Sign up
      • Sign-up without a Google account
    • Quickstart
    • Ask for Help
      • Support Tickets
      • Support Codes
      • Screenshots
      • Developer Console
      • 400 Error
      • Resolve: API developer key is invalid error
      • How to request a transfer of your Portant account
    • Templates
  • 💫Personalise Documents
    • Adding Hyperlinks
    • Adding Images
    • Use custom tag names
    • Tag Formulas
      • Global tags
      • Tag Formulas
      • Tag IF Statements
    • Invalid Tags
    • Portant AI Content
    • Dynamic Google Sheets Charts
    • Tag Checker
    • Add online payment links
    • Add Stripe Payment Links to Your eSign Portal
  • 🌐Sources
    • Google Forms
      • Add formula fields to your Google Form workflow
      • {{tags}} for Google Forms
    • Google Sheets
      • Google Sheets Auto-create
      • How to source data from multiple Sheets
      • Saving Document Links to your Sheet
      • Data Grouping
    • HubSpot
      • How to install the Portant App in HubSpot
        • How to Add Portant App Cards to HubSpot
      • Create a Document in HubSpot
      • How to manage and select HubSpot Properties
        • Full list of available HubSpot Properties
      • Trigger HubSpot Workflows from Portant
      • Add a Portant Action to a HubSpot Workflow
      • How to view created documents in HubSpot
      • Add multiple line items into a single document
      • Add Deal Tags using Portant document statuses
      • Portant eSignatures + HubSpot
      • Review and approve documents in HubSpot
      • Generate Documents from any Custom Object in HubSpot
    • Zapier
    • Glide
    • Webhooks
      • Webhook Data Grouping
    • Xero
    • Copper
      • Installing the Copper integration
      • Create your first Copper workflow
      • Generating your first document from Copper
    • Typeform
    • Tally
  • 📄Template Docs
    • Google Docs
    • Google Slides
    • Microsoft Word
    • Microsoft PowerPoint
    • Fillable PDF
  • 💡Use Cases
    • eSignatures Requests
    • Incident Report
    • Quarterly Business Reviews
    • Invoices
    • Convert Form Responses to PDFs
  • ✒️eSignatures
    • Getting Started
    • Request Signatures (without a source)
    • Request Multiple Signatures
    • Customise Signature Request Email
    • Create Preview Links for Signature Requests
    • Resend signature requests
    • Cancel Signature
    • Add Audit to eSignatures
    • Request Info On Signing
    • eSigning Laws & Compliance
      • United States: E-SIGN Act and UETA ✅
      • Canada: PIPEDA and Electronic Transactions Act ✅
      • EU: eIDAS Regulation for Electronic Signatures ✅
      • UK: eIDAS Regulation and Electronic Communications Act 2000 ✅
      • Australia: Electronic Transactions Act (ETA) ✅
      • New Zealand: Electronic Transactions Act (ETA) 2002 ✅
      • Israel: Electronic Signature Law 2001
  • ⚡Automation
    • Workflow Filters
    • Re-run an automation
    • Review Block
    • Review and Approve Documents
    • Converting docs to different file types
      • Microsoft Word (.docx)
      • Microsoft Powerpoint
      • Create PDF outputs
      • Save an output as a Microsoft Excel file (.xlsx)
  • ✉️Emails
    • Share a Doc via Email
    • Email Tracking
    • Send from aliases
    • Send Outlook Emails
    • Customize Your Email Content with HTML Editing
  • 📄Outputs
    • Customize Output File names
    • Auto-filing Output Files
    • Changing Output Folder
    • Search and filter your outputs
  • Deleting Outputs in Portant
  • 🎁Portant Add-ons
    • Data Merge
      • How to set-up a Google Sheets source
        • Data Merge Settings for Google Sheets sources
        • Automatically create documents
      • How to set-up a Google Forms source
        • Data Merge Settings for Google Forms
        • Automatically create documents
        • Edit Response and Pre-filled Response Links
      • Inserting Images
      • Advanced Settings
        • Editing tag names
        • Timezone, date and time format settings
        • Editing the Output Folder
        • Conditional logic for emails
        • Conditional Logic for Data Merges
        • Data Grouping in Portant Data Merge
    • Document Merge - Trello Power-up
  • 👥Teams
    • Creating Your Team
    • Sharing Workflows
    • Creating Folders in the Workflows Tab
    • Managing team permissions
    • Whitelabeling eSign Portal
  • ⚙️Settings
    • Change Language Settings
    • How to Set Up Your Account's Global Formatting Settings
  • Delete Multiple Workflows at Once
  • 💳Billing
    • Update Billing
  • Developer
    • Build with Portant
Powered by GitBook
On this page

Was this helpful?

  1. Sources
  2. Google Sheets

Google Sheets Auto-create

How to automatically create a document every time a new row is added to your spreadsheet (or a row has changed)

PreviousGoogle SheetsNextHow to source data from multiple Sheets

Last updated 6 months ago

Was this helpful?

Note - this is a ✨ Pro feature only avalaible on paid Portant Subscriptions

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

  4. Auto-create when a specific value changes e.g. Status

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:

Auto-create when row data changes

Sometimes you might want to run auto-create when data in a row changes. Portant takes a snapshot of the data in your spreadsheet at the time this feature is turned on. Then whenever a change in the data is detected, Auto-create will process the row with the 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

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

Feedback and feature suggestions

If you can't see this status, Auto-create is not on.

You can combine this feature with a that enables you to only process 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 to only process data when the 'Status' is 'Send'

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

🌐
workflow filter
workflow filter
contact@portant.co