CSV to Maps Workflow Automation

Job ID: 40209379

Budget: $15 – $25 USD

I already have a clean Microsoft-format CSV that contains nothing but street addresses. What I need is a repeatable workflow—code, no-code, or a hybrid—that takes that file, lets Google Maps (Places API or a comparable method) look up each address, pulls every business name that exists at that location, and then writes the results into a Google Doc. For the document layout I want the address shown once, followed immediately by a simple list of all business names found at that spot (no tables, no extra formatting).

Key points you should respect:
• The CSV is finished and ready to ingest as-is.
• If more than one business is tied to an address, keep every name.
• Output in Google Docs: one address followed by its full list, then move on to the next address.

I’m open to whatever stack feels most efficient—Python with pandas, Google Apps Script, Zapier, Make.com, or a custom API integration—as long as the final flow can run on demand and is documented well enough that I can swap in a new CSV whenever needed.

Deliverables I expect:
• Working automation (script, scenario, or add-on) that accepts my CSV and produces the Google Doc exactly as described.
• Brief setup/usage instructions and any API keys or service-account steps I need to replicate the run.
• A short test run showing that the addresses map correctly and every business name appears under its respective address.

I value clean, well-commented code and straightforward instructions. Let me know the tools you plan to use and an estimated turnaround, and we can get started right away.