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
    • Delete Multiple Workflows at Once
  • How to Set Up Your Account's Global Formatting Settings
  • Change Language Settings
  • 💫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 documents using the Review Block 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
  • 💡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
    • 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
  • 💳Billing
    • Update Billing
  • Developer
    • Build with Portant
Powered by GitBook
On this page

Was this helpful?

  1. Use Cases

Invoices

How to easily automate your invoicing process

PreviousQuarterly Business ReviewsNextConvert Form Responses to PDFs

Last updated 5 months ago

Was this helpful?

Utilizing automated invoicing can significantly enhance efficiency by saving valuable time and minimizing the risk of mistakes. Moreover, you can conveniently manage all your data in your existing Google Sheet and track invoices seamlessly.

In this article, you'll learn how to:

  1. How to create a new workflow

  2. How to customize your invoice

  3. How to add calculations

  4. How to share your invoices via email

  5. How to customize the file settings

  6. How to set up a "Record Outputs" block

  7. How to run the automation

  8. How to automatically run a workflow directly from the template gallery

How to create a new workflow

The first step is to click on "+ Add Workflow":

Next, choose a source document. All the data in your invoice document will be retrieved from a Google Sheet document:

Now that you've chosen your source document, click on the plus icon to select your template document:

Select a Google Doc template:

After selecting your invoice template, take note that on the right side of your screen, you'll find a source table. This table can be used to easily copy all the tags you require for placement into your invoice document template:

Note: A {{tag}} is how Portant identifies where the source data is inserted in your template.

Next, designate an Output Name for the documents you're about to generate. Keep in mind that you can also incorporate tags here. In this particular instance, we are utilizing the tags "{{Invoice Number}}" and "{{Customer Name}}". And don’t forget to click enter to same the new file name structure

‍

Activate the "Create PDF copy" option. By doing so, you ensure that a PDF copy of the invoice will be saved in your output page and Google Drive folder:

‍How to add calculations to your invoices

Sometimes you might need a way to add a total to your invoice (or other types of calculation). Within Portant, you can add calculations for a few simple formulas.

Note: These formulas only work with Data Grouped fields

Sum To add all field values within a Data Group together

{{=SUM(*Field name*)}}

Average To average all field values within a Data Group

{{=AVG(*Field name*)}}

Maximum To find the Maximum value from a group of field values within a Data Group

{{=MAX(*Field name*)}}

Minimum To find the Minimum value from a group of field values within a Data Group

{{=MIN(*Field name*)}}

How to share your invoices via email

Click on "Share document via Gmail".

Note: You may also share the created documents by Outlook.

Tailor your email to your preferences by incorporating the tags you deem most suitable:

Note: Alternatively, you can add the email block by clicking the plus icon here:

‍

Click on "Add attachments"

Select the desired attachment format for sending the invoice. In this example, we are choosing to send it as a PDF file:

Then, save:

‍

How to set up a "Record Outputs" block

You also have the option to include a "Record Outputs" block. This block adds a link to the generated output in a new column in your source document.

Here are the columns that will be generated in your source document, each containing links to the corresponding generated outputs:

Since we have enabled the "Create PDF copy" option, we will also see the generated output files on our output page for viewing:

If you click on the lightning icon, you will see all your workflow blocks. The green ticks show that all stages are correctly set up:

Click "Automate" and then click "Start". Your invoice documents will now be created:If

Keep in mind that you can execute this workflow for a specific customer range rather than processing all the data from your source document. To do this, select the "customer range" option as shown below:

How to automatically run a workflow directly from the template gallery

After selecting the workflow you want, click "Copy Workflow":

Portant now will create a copy of this workflow within the workflow gallery:

You now have all your workflow blocks already configured like this:

Subsequently, customize each block to align with your specific requirements, as exemplified earlier in this article.

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

How to customize your invoice

How to customize the file settings

How to run the automation

Finally, if you want Portant to automatically run this workflow every time new data is detected in your source document, activate the "Auto-Create" mode. For more information on this feature, please,.

Keep in mind that our template gallery offers a wide variety of workflow templates, accessible at this . We will provide you with a template and a source document that you can easily edit directly within Portant. Simply navigate to our template page and select the workflow of your choice. In this instance, we have opted for the Invoice Workflow template:

💡
click here
link