Generate B2B Leads by Industry & Location with Google Places API and Google Sheets

About

How it works A form trigger accepts an Industry + Location query (e.g. Accountants London). Text Search Page 1 calls Google Places Text Search to return results and a next_page_token. Conditional checks + 5s wait nodes fetch page 2 and page 3 when a next page exists. All pages are merged, split into individual place results, and each place_id is passed to Place Details. Place Details returns name, formatted_phone_number, website, formatted_address. Results are formatted and appended to a Google