Last updated:
Quick answer
Give an AI bot the file and a list of fields, and ask for one row per record with the page number. Spot-check rows against the PDF before you use the sheet.
At a glance
All outcome figures are estimates from cited sources, not independent verification by us.
- What it is allowed to do
- Drafts for you
Writes drafts (emails, posts, plans, replies). You review and send. Nothing goes out without you.
- Time saved (estimate)
- Not measured yet
- Difficulty
- Intermediate
- Tools needed
- AI bot, Google Sheets
- Typical cost
- For small jobs, paste the text into a free AI chat and ask for a table you can paste into Sheets. Other tool costs are not stated in sources.
Reviewed Oct 20, 2026
Basis (estimate): Not measured yet. Their claim; no file sizes or times shared.
What does this setup do?
Read PDF or Word files, pull the fields you name into a Google Sheet (one row per record, with the source file and page), and optionally fill a web form that stops for your approval before submit.
Who is it for?
People with big PDFs and Word files full of numbers they need in a spreadsheet, who then have to type the same data into web forms.
How do you set it up?
Tools
- Extractor bot: reads the PDF or Word files on your computer and pulls the fields you name into rows.
- Sheets step: puts those rows in a Google Sheet, one row per record, with a column for the source file and page.
- Form helper (optional): fills a web form from a row, then stops and shows you a screenshot. You check it and click submit yourself.
Steps
- Extractor bot: reads the PDF or Word files on your computer and pulls the fields you name into rows.
- Sheets step: puts those rows in a Google Sheet, one row per record, with a column for the source file and page.
- Form helper (optional): fills a web form from a row, then stops and shows you a screenshot. You check it and click submit yourself.
Example output
Illustrative. Your results will differ.
- One row per record, with the source file and page number
- Unclear values left blank, with a note, plus a count of rows and anything skipped
- A filled web form stopped before submit, with a screenshot for you to approve
Where to paste this prompt
ChatGPT: ChatGPT → Project instructions, or ChatGPT Tasks for scheduled reminders (once a day on Free)
Copy-paste prompt
Adapt bracketed fields to your situation.
Read the files in [FOLDER] (PDF and Word).
Pull these fields from each record: [FIELD 1], [FIELD 2], [FIELD 3].
Put one record per row in a Google Sheet called [SHEET NAME], with two extra columns: source file and page number.
If a value is unclear or missing, leave the cell blank and add a note. Don't guess.
When done, give me a count of rows and a list of anything you skipped.
Web forms: fill [FORM URL] from row [N] only after I say go. Stop before submitting, show me a screenshot of the filled form, and wait for me to approve. Never submit on your own.Newsletter
Get the free starter pack
Free starter pack with five beginner copy-paste prompts after you confirm, plus three sourced setups in your inbox each week. Unsubscribe anytime.
What usually goes wrong?
Where agents tend to stall on this job. More patterns in Where AI gets stuck.
- Scanned PDFs and tables that cross pages are where extraction slips. Check a sample of rows against the source page numbers before you use the sheet for anything that matters.
Which chat tools work with this prompt?
Paste the prompt into any of these assistants (free or paid tiers).
- ChatGPT
- Claude
- Gemini
Common questions
- How do I extract data from a PDF to Google Sheets?
- Give an AI bot the file and a list of fields, and ask for one row per record with the page number. Then spot-check rows against the PDF.
- Can AI read large PDF files?
- Many AI bots can, especially if they can open files on your computer. Very long files may need to go in parts.
- Can I convert a PDF to Google Sheets for free?
- For small jobs, yes: paste the text into a free AI chat and ask for a table you can paste into Sheets.
- Can AI fill out web forms for me?
- Some bots can control a browser and fill forms. Have it stop before submitting so you check every field first.
What tips make it smoother?
- If a value is unclear or missing, leave the cell blank and add a note. Don't guess.
- Have the bot stop before submitting a web form, show you a screenshot of the filled form, and wait for you to approve. Never let it submit on its own.
- Very long files may need to go in parts.
Where do the claims come from?
Summaries use public sources linked below, not independent verification. How setups are picked.
- Read @realYitangWang’s write-up (x.com)
@realYitangWang: Says their bot filled web forms, worked through Word, PDF, and Google Sheets files, and pulled data out of large PDFs stored on their own computer faster than they expected. Their claim; no file sizes or times shared.
Related setups
- Log receipts by photo instead of typing
Photograph receipts and have AI pull out vendor, date, and total into a running expense sheet.
- Use Gemini inside Google Sheets
Use Gemini inside Google Sheets: AI formulas that categorize and summarize row by row, plus a side panel that builds sheets and dashboards from prompts.
- Extract vendor invoices and bundle the month for accounting
When invoice email arrives, extract vendor, amount, due date, and invoice number into a tracker; at month-end, bundle PDFs plus an index for your accountant after you approve.