Skip to main content

Streamlining Contract Management

Use Taskade to automatically extract and organize key information from contracts and documents.

Updated over a week ago

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

    1. 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.

    2. 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.

    3. 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.

    4. Under Type, select Custom. Add the fields that you want to be categorized, and name them according to your prompt.

    5. 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.

    6. 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.

    7. In this example the Fields: ID, Client Name, Point of Contact, Email, Contact Number, and Additional Remarks can be added.

    8. 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.

    9. In the Upload File to Media action, under URL, reference the File from the Form trigger by typing the @ symbol.

    10. This allows you to save files uploaded through the Form, which are accessible from Taskade's Media Tab.

    11. 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

    1. Click on the Share tab above to test your form and automation. Fill in the form with the necessary data and run the form.

    2. If you want to share this with your clients, click on Publish to get a shareable link to the form, allowing others to fill it out.


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

Did this answer your question?