Apps Script Automator
Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.
You fill in PipelineOwnerStage
A Gemini prompt that reads photos of receipts and returns a clean expense table you can paste straight into Google Sheets.
Reads photos of receipts and returns a clean expense table you can paste straight into Google Sheets.
I want you to act as a bookkeeping assistant who reads receipts. I will attach photos or PDFs of receipts, and you will turn them into one clean expense table. For each receipt, read the merchant, the date, the currency, the total, the tax amount if it is printed, the payment method if it is visible, and the individual line items when they are legible. Put the result in a table with the columns Date, Merchant, Category, Description, Net, Tax, Total, Currency, Payment Method, File. Use these categories and no others: travel, meals, accommodation, software, equipment, office supplies, marketing, fees, other. Format dates as YYYY-MM-DD. Keep amounts as plain numbers with two decimals and no currency symbol inside the number column. Never guess a figure you cannot read. Where a value is unclear, write UNREADABLE in that cell and add the receipt to a short list at the end called Needs a human, saying exactly which field failed. Do the same for a receipt that is cut off, blurred, or in a language you are unsure of, naming the language. After the table, give me three lines: the total per category, the total overall per currency, and any receipt that looks duplicated, naming both files. Do not give tax advice and do not decide what is deductible. My first request is: "Here are eleven receipts from a conference trip. [attach the files]"
Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.
You fill in PipelineOwnerStage
Turns a rough question into a scoped Deep Research brief: sub-questions, preferred sources, exclusions, report outline…
You fill in cut-off datethe market for AI note-taking…Q3 build-or-buy decision
Line-edits any Google Doc you link, returning a tightened draft plus a change log while keeping your voice and required terms.
You fill in confirm figurerequired terminologywho will read this+3 more
Reference a Gmail message and get three ready-to-paste reply drafts in your own voice, short, standard and detailed.
You fill in confirm datenameDaniel Okafor+1 more
Turns a long Gmail thread into decisions, open questions, owner-and-deadline actions and one suggested next step you can send.
You fill in subjectnumberdate of first+4 more
Paste this Gemini prompt to turn a long report, PDF or Google Doc into a slide-by-slide deck outline with titles, bullets, speaker notes and visuals.
You fill in confirm figurenumbertitle of under eight words+3 more
One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy