Apps in this workflow

How it works

Build your automated pdf to text extractor in a minute! Perfect solution for those who deal with large amounts of incoming CVs or other documents! Extract data from documents using remote workflow on Latenode.com!

ā€
In this article youā€™ll see how to create an automated no code workflow that will extract data from the PDF files on your Google Drive using API and Chat GPT, and filling the Google Sheet form with the data.

Also, you can get the template of that scenario that you can copy and use for yourself for free!Ā 

You can upgrade this template or use it not only for pdf text extraction.

Scenario overview

Letā€™s take a look at the whole pdf scraper scenario first, and then break each step down.

Illustration of Scenario overview on Latenode

ā€

How does this pdf extract scenario work? Once in an hour it takes all the CVs in pdf format from the Google Drive, converts to the txt files using HTTP-request, then chatGPT assistant Extracts the needed data and fills out the Google Spreadsheet.

Main steps of scenario:

  1. Schedule Trigger. Activates the scenario at a set period of time.
  2. Google Drive. Here we have 2 nodes: Find file and Download File.
  3. Javascript. Weā€™ll use Javascript nodes with AI copilot for file formatting throughout the scenario. First, I asked AI to give me code that converts files from Google Drive to base64 format.
  4. HTTP request. Use API to extract text from pdf using tried party services API docs.
  5. ChatGPT. Ā ChatGPT assistant extracts the data from the text.
  6. Google Sheets. Fills out the sheet with that information,

Scenario breakdown

And hereā€™s a step-by-step instruction for those who want to learn the process. Remember about free to use and ready to go templates at the end of the article.

Preparations

For this scenario, youā€™ll need to have the ability to use Open AI Assistants and any API converter.

OpenAI assistant

That is simple. Log into your OpenAI account, then go to assistants, and click the ā€œcreateā€ button in the upper right corner. Youā€™ll see the assistant's settings panel.

Illustration of AI assistent right settings

Here you need to:

  1. Give your assistant a name
  2. Give it instructions on how you want it to answer, and some context. We recommend you to ask it to use attached files, ā€˜cause otherwise, it can forget to do it.
  3. Choose a model
  4. Select available tools and add files that the assistant can use. Donā€™t forget to turn retrieval on to make file adding possible.

Copy the assistantā€™s ID (you see it under the Name column), then go to API keys, create one and save it.

PDF to TXT converter

Use any you like. I took ConvertAPI because it has a free trial and provides a lot of info.

ā€

Illustration of ConvertAPI app to create automete converter from pdf to text

Create scenario

Now we switch to Latenode.com. Here, we have to create the pdf to text conversion scenario: (You don't need to create it from scratch, just copy the template at the end of the article)

Schedule trigger

Illustration of schedule trigger

Click ā€œAdd nodeā€ in the scenario tab, choose ā€œScheduleā€ from the list. Click on the node to set it up. Specify the interval and the timezone, save the changes. I also added a trigger on Run once, just for convenience.

Google Drive nodes

Illustration of Google Drive nodes

Click ā€œAdd nodeā€, search for Google drive folder in actions tab, and choose ā€œFind fileā€ node.
To make it work you have to log into gmail account to get access token, choose drive and Search name. In this case, I want to extract data from files that have CV in their name.

ā€

Next add ā€œDownload fileā€ from the same action folder of Google drive.

Illustration how to download file you need to create AI pdf-text converter

Use id from the results of the previous node, and then click run node once to save the changes and make the data flow through the scenario. Youā€™ll get the file in the output.

Javascript #1: Convert to base64

Illustration of JS code you need To extract Text

That is the code the AI gave me. You can take it here(#1). Replace const fileContentPath with your object from the previous node.

HTTP request

Find HTTP request in the list of actions. To understand how to create it, visit ConvertAPI documentation. Here we can take info about setting up the request.

Hereā€™s how my pdf to txt conversion request looks like.

Illustration of right HTTP reques settings

ā€

I use an object from Find file Google Drive node to specify the name of the downloaded file, and file content in base64 from the Javascript node. And add Content-Type=application/json pair in Headers.

Illustration of right HTTP reques settings

Run node once to get the file from the HTTP request.

Javascript #2

Illustration of JS code you need To extract Text

Another code node, #2 here.

This time, I asked AI to extract text from the txt file.

ChatGPT nodes

Weā€™ll face 3 GPT nodes here:

  • Create Thread
  • Create Message
  • Create Run

Ā Each node performs an action with OpenAI.

First we create a thread, or conversation with the GPT Assistant

Illustration how to create ChatGPT nodes and how to use AP key

Insert your Open AI API key, thatā€™s it! Run node once and get the id of the created thread in the output.

Create message:

illustration how to create right massage for AI Support Assistent

Here you need an API key again. In the thread ID field put the result of the previous node. Youā€™ll see it in the helper window after you click on the input field.

In ā€œMessage contentā€ give some additional instructions if you want and put the filecontent from the last Javascript node. Automated pdf extractor is one step closer!

Create Run

Illustration How to create your run to watch the result

This node gets the pdf scraper reply.

Specify the node just like your OpenAI assistant and use GPT assistant ID.

Javascript #3

Illustration of JS code you need To extract Text

Here we use JS node the last time, to make 3 separate json objects out of the Assistants reply.

Hereā€™s the example, just put your data in content const.

Google Sheets

Letā€™s put this data somewhere, Google Sheets is a good option for this pdf data extract scenario on latenode.com.

illustration of Google Sheets settings you need

Log into gmail account once more to get access token, choose the drive and the sheet, and put jsons into the fields, save the scenario and click run once to run or deploy the scenario to activate the schedule trigger.

Results

The reslts of work we have done

After a successful scenario execution this workflow will extract the text from pdf file on your Google Drive and put it into your Google Spreadsheet.

That is how to create a pdf extractor with no code on latenode.

As I promised, hereā€™s the template of this workflow. Just copy it and follow this guide article to set it up.

Thereā€™s a video about it, donā€™t bother reading!

If you want somebody to help you, check out our Discord channel, we have some devs in it ready to assist!

ā€

Categories

AI
IT & Development
Advertising & Marketing

FAQ

Can I use Latenode if I'm not familiar with programming?

Yes, Latenode is designed for users of all skill levels. It offers advanced features for those proficient in JavaScript and intuitive visual tools and AI assistance for beginners. Whether you're an experienced developer or a novice, Latenode provides a user-friendly experience tailored to your skill level.ā€ā€

Can Latenode integrate with third-party services and APIs?

Yes, Latenode supports integration with a wide range of third-party services and APIs. You can connect Latenode to various online platforms, databases, and software systems to automate data transfers, trigger actions, and streamline workflows. Latenode also provides tools and resources to facilitate the integration process.

Is there a free version of Latenode available?

Yes, Latenode offers a free version that lets you explore its capabilities. This version includes a subset of Latenode's features, enabling you to start with automation and experience its benefits. You can then decide whether to upgrade to a paid plan for additional features and resources.

What is Latenode?

Latenode is a visible and intuitive automation tool designed to empower customers to streamline their workflows through automation. It allows customers to create computerized strategies via connecting diverse internet offerings and gadgets, permitting them to automate obligations and decorate productivity successfully.

How does Latenode help maximize opportunities?

By integrating all your marketing tools in one place through data integration, Latenode helps you gain a comprehensive view of your operations. This enables you to identify potential opportunities more easily and make informed decisions based on accurate data.