How to Extract Bank Statement Data to Google Sheets Using Pabbly Connect

Learn how to automate the extraction of bank statement data to Google Sheets using Pabbly Connect. Step-by-step tutorial for seamless integration. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin extracting bank statement data to Google Sheets using Pabbly Connect, first, you need to access the Pabbly Connect platform. Simply open your browser and search for ‘Pabbly.com/connect’ to reach the landing page.

Once on the page, you will see options to either sign in or sign up for free. If you are a new user, click on the ‘Sign up for free’ button to create an account. Existing users can click on ‘Sign in’ to access their accounts and proceed to the Pabbly Connect dashboard.

2. Creating a New Workflow in Pabbly Connect

In this section, you will create a new workflow that will automate the extraction of bank statement details. Click on the ‘Create Workflow’ button in your Pabbly Connect dashboard.

• Name your workflow as ‘Extract Bank Statement Data into Google Sheets Using AI Agent’.
• Select the appropriate folder to save your workflow.
• Click on the ‘Create’ button to finalize your workflow setup.

Upon clicking ‘Create’, you will be taken to the workflow window where you can set up triggers and actions. This is the core area of your automation using Pabbly Connect.

3. Setting Up Google Drive Trigger in Pabbly Connect

Now, you will set up the trigger for your workflow. Select ‘Google Drive’ as the trigger application, and for the trigger event, choose ‘New File in a Specific Folder’. using Pabbly Connect

Next, click on the ‘Connect’ button. If you have already connected your Google Drive account, select the existing connection. If not, click on ‘Add a New Connection’ to link your Google Drive account. You will need to sign in with your Google account and allow necessary permissions.

• Select the folder where your bank statements are stored.
• Ensure the folder has sharing permissions set to ‘Anyone with the link can edit’.
• Click on ‘Save and Send Test Request’ to verify the connection.

After successfully setting up the trigger, Pabbly Connect will check for new files in your Google Drive every 10 minutes, which means it will automatically initiate the workflow when a new bank statement PDF is uploaded.

4. Extracting Data Using AI Agent in Pabbly Connect

Next, you will set up the action step to extract data from the uploaded bank statement using an AI agent. Choose ‘OpenAI’ as the action application and select ‘Extract Content from PDF/Image’ as the action event. using Pabbly Connect

Click on ‘Connect’ and either select an existing connection or create a new one by entering your OpenAI API key. After entering the key, select the OpenAI model (e.g., GPT-4 Mini) and map the PDF URL from the previous step.

Enter a prompt for the AI agent, like ‘Extract me the details from the given PDF’. Generate a structured output JSON schema to define the data format. Click on ‘Save and Send Test Request’ to extract the bank statement details.

Once the AI agent processes the data, it will return the extracted details, which can then be sent to Google Sheets using the next action step.

5. Adding Extracted Data to Google Sheets

For the final step, select ‘Google Sheets’ as the action application and choose ‘Add a New Row’ as the action event. Click on ‘Connect’ to link your Google Sheets account.

After connecting, select the spreadsheet and sheet where you want to store the extracted data. Then, map the extracted data fields from the previous step to the corresponding columns in your Google Sheets.

Map the fields such as Account Holder, Account Number, and Transaction Details. Click on ‘Save and Send Test Request’ to add the data to Google Sheets. Verify that the data appears correctly in your Google Sheets document.

With this, you have successfully set up an automated process using Pabbly Connect that extracts bank statement data and adds it to Google Sheets without any manual intervention.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the extraction of bank statement data to Google Sheets. By following these steps, you can save time and reduce errors in your financial documentation process.