Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to automate PDF text extraction and data processing using AI-powered tools in this comprehensive tutorial. Master the complete workflow of finding PDF attachments in Gmail, extracting text from PDF receipts, and automatically organizing the data in Google Sheets using Make.com automation platform. Explore the fundamentals of Make.com including triggers, array aggregators, and Google Drive integration before diving into advanced techniques with 0CodeKit for AI-powered text extraction. Discover how to leverage ChatGPT to structure extracted data, create JSON formats, parse the results, and seamlessly transfer information to Google Sheets. Follow along with detailed demonstrations of each automation component, from initial setup through final implementation, while learning practical applications for receipt processing and document management. Gain insights into additional use cases for PDF automation and understand how these techniques can streamline business processes and reduce manual data entry tasks.
Syllabus
0:00 Intro
0:22 Concept overview
2:58 Building the Make.com automation
3:05 Make.com overview
3:56 Make.com trigger
10:29 Array aggregator in Make.com
13:16 Google Drive in Make.com
15:57 Google Drive share link in Make.com
19:36 0CodeKit In Make.com - extracting text with AI
23:49 ChatGPT - pulling out variables and structuring data with AI
27:40 Create JSON data using AI
32:20 Parse JSON
38:18 Adding data into Google Sheets
43:07 Additional use cases
44:11 Conclusion
Taught by
Jono Catliff