Overview
Today, you’ll learn how to use Taskade’s AI Forms to streamline the contract tracking process. Clients can submit forms with attached documents directly through Taskade - where Taskade can automatically extract and organize data from documents into a Google Spreadsheet, streamlining the entire process.
Click here to access the bundle and quickly get started.
Here's what we'll cover:
How to set up an automation to collect form data including attached documents, filter key information and add it into an existing Google Spreadsheet.
Testing the automation, and publishing the form for client use.
Creating the Automation
Create the Automation
Create a trigger and select Form. Add the Form Fields you want to collect. To collect data from uploaded files, you will need to add a File field.
Add the actions: Convert File to Text, Categorize with AI (custom), Insert Row, Upload File to Media, and Add Task.
In the Convert File to Text action, reference the file URL from the Form trigger that you want to convert, by typing the @ symbol. This converts the document into text that can be used in the next step.
In the Categorize with AI action, input a prompt requesting the AI to extract and categorize information as needed from the Convert File to Text action. Type the @ symbol to reference the content from the action.
Under Type, select Custom. Add the fields that you want to be categorized, and name them according to your prompt.
In this example, I've added the fields: Client Name, Point of Contact and Email. This will allow the AI to properly categorize the information.
In the Insert Row action, connect your Google Account and select the related Spreadsheet and Sheet. The Fields that can be added in the action will always refer to the content in Row 1 of the Sheet.
In this example the Fields: ID, Client Name, Point of Contact, Email, Contact Number, and Additional Remarks can be added.
Add the respective fields and reference the key information from the Categorize with AI action or the Form trigger by using the @ symbol to fill up the columns with the right data.
In the Upload File to Media action, under URL, reference the File from the Form trigger by typing the @ symbol.
This allows you to save files uploaded through the Form, which are accessible from Taskade's Media Tab.
Instead of using Google Sheets, you may organize the information in Taskade Projects (Table View). In Add Task, select the appropriate Project. The Fields in the Project refer to the column names.
Testing and Sharing the Form
Testing and Sharing
Additional Customization
Additional Actions
Consider adding additional actions like Add Task, Send Email, that make use of the information from the Form. Simply reference the Form fields, or content from the Categorize with AI action with the @ symbol.
😊 Helpful Links
Download our apps: taskade.com/downloads
Leave feedback: taskade.com/feedback
Changelog: taskade.com/blog/updates
Watch tutorials: youtube.com/taskade
Contact us: taskade.com/contact