This document explains how to connect a Google Sheet, map columns, and process documents so that extracted information is automatically sent to your Google Sheet.
Step 1: Open the Integrations Page
From the Toolbox menu, go to the Integrations page.
Step 2: Set Up the Google Sheets Integration
On the Integrations page, locate Google Sheets and click Set Up.
Paste your Google Spreadsheet ID into the provided field. You can find this ID in the sheet URL: it is the long string after /d/ and before /edit. Copy that value and paste it into the Spreadsheet ID field. Click Continue to proceed.
Step 3: Authenticate and Select Your Sheet
Authenticate with your Google account when prompted and click Allow access to grant access.
After access is granted, select the Google Sheet you want to use for the integration.
Then click Insert to confirm your selection.
Step 4: Configure Column Mappings
Configure how your data fields map to columns in the Google Sheet. Click through all columns on the left side to map fields from the document processor to your Sheets columns. These fields should correspond to the existing column headers in your Google Sheet.
Step 5: Go to Your Workspace and Process a Document
Navigate to your workspace where you manage documents.
Click Process to on the document.
Step 6: Send Data to Google Sheets
Review and confirm the extracted information. When everything looks correct, click Send.
In the sending options, select Process with Google Sheets. Then click Next to finalize the data. Lastly, click Send.
You will see a confirmation message. Open your Google Sheet to verify that the uploaded information now appears in the mapped columns.
If you have any other questions, please reach out to support@documo.com.