Hey folks, I built this workflow for an influencer marketing agency that gets 20–30 invoices every week via WhatsApp/Telegram in all sorts of formats — PDFs, Word docs, JPGs, PNGs.
Until now, someone was manually extracting all the data into Google Sheets — a super time-consuming process. So I set up this automation:
- If the invoice is a PDF, it follows 1st branch.
- If it’s a .docx, follows 2nd branch, where it first gets converted, then processed.
- If it’s an image (jpg/png), it’s analyzed and extracted in the 3rd branch
- If it's an image as a document it goes to 4th branch
- Finally, the structured data is pushed into a Google Sheet.
The workflow works, but right now I’ve built separate flows for each file type, which makes it long and (probably) more complex than it needs to be.
👉 I’d love feedback from the community on how to optimize/shorten this workflow while still handling multiple file types reliably.