Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Automation

To start automating data extraction from images, you first need to access Pabbly Connect. Visit pabby.com and log into your account. If you’re new, you can sign up for free, allowing you to explore its features.

Once logged in, navigate to the Pabbly Connect dashboard. This is where you can create workflows that will automate your tasks. You can create a new workflow by clicking on the designated button and naming it appropriately.


2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow to extract text from images uploaded in Google Drive using Pabbly Connect. Start by clicking on ‘Create Workflow’. Name it something relevant, like “Extract Data from Images with AI”.

  • Select the folder where your workflow will reside.
  • Once created, set up the trigger application as Google Drive.
  • Choose ‘New File in a Specific Folder’ as your trigger event.

After setting the trigger, connect to your Google Drive account. This connection will allow Pabbly Connect to monitor the specified folder for new files. Ensure you grant the necessary permissions when prompted.


3. Uploading Images to Google Drive

Now that the workflow is set, upload an image to your specified Google Drive folder. This image will be the source from which you want to extract text. Ensure the image is shared with anyone who has the link to facilitate access.

After uploading, go back to your Pabbly Connect dashboard and test the connection. You should receive a positive response indicating that the image has been detected successfully.


4. Extracting Data Using OpenAI

The next step in your workflow involves using OpenAI to extract text from the uploaded image. In Pabbly Connect, add a new action step and select OpenAI as your action application.

  • Choose ‘Extract Content from PDF/Image’ as the action event.
  • Connect using your OpenAI API key for authentication.
  • Map the URL of the uploaded image to the appropriate field in OpenAI.

In the prompt field, instruct OpenAI to extract all visible text content from the image. This will ensure that the output is formatted correctly and retains the layout of the original text.


5. Adding Extracted Data to Google Sheets

After extracting the text, the final step is to add the data to Google Sheets. Add another action step in your Pabbly Connect workflow and select Google Sheets as the application.

Choose ‘Add New Row’ as the action event. Connect to your Google Sheets account and select the spreadsheet where you want the data to be added. Map the extracted text, file name, and URL to their respective fields in the spreadsheet.


Conclusion

By following these steps, you can effortlessly automate the process of extracting text from images using Pabbly Connect, Google Drive, and OpenAI. This integration allows for seamless data management and enhances productivity.