Enrich a company list in Google Sheets

Build an agent workflow that enriches a company list inside a Google Sheet.

Trigger: manual launch. The workflow has one required text input called "Spreadsheet URL" where the user pastes a full Google Sheets link (https://docs.google.com/spreadsheets/d/<spreadsheetId>/edit#gid=<gid>).

What the agent should do when launched:

1. Parse the spreadsheet URL from the input to extract the Spreadsheet ID and the Sheet ID (the gid in the hash).

2. Call Google Sheets to fetch the spreadsheet metadata, find the tab whose sheetId matches the gid, and use that tab's title for all subsequent reads and writes.

3. Read all rows and the header row of that tab. Locate these columns by header name: "Company Name", "LinkedIn Page", "Employee Count", "Annual Revenue (Est)", and "Enrichment Status". If any of LinkedIn Page, Employee Count, Annual Revenue (Est), or Enrichment Status are missing, append them as new columns to the right of the existing data and re-read so the column indexes are correct.

4. Identify rows to enrich: any row where Company Name is non-empty and Enrichment Status is not exactly "Enriched". Skip everything else.

5. For each row to enrich, use Internet Search to find: the official LinkedIn company page URL, the most recent publicly reported employee count, and the most recent annual revenue estimate. Run separate targeted searches per field and prefer authoritative sources (LinkedIn, the company website, Wikipedia, Crunchbase, major business press).

6. Standardize the values before writing them back:

- LinkedIn Page: full HTTPS URL to the company page (e.g. https://www.linkedin.com/company/acme).

- Employee Count: comma-separated integer such as 12,500. Use the latest single number; if only a range is available, use the midpoint.

- Annual Revenue (Est): formatted string like "$86.4 Billion" or "$378.1 Million". One decimal place, currency symbol, magnitude spelled out.

- Enrichment Status: set to "Enriched" only when all three fields have confident values.

7. Submit all cell updates in a single Batch Update Values request to Google Sheets so the spreadsheet is written once at the end, not row by row.

8. Output a summary table of the rows that were enriched (Company Name, LinkedIn Page, Employee Count, Annual Revenue) and a direct link back to the spreadsheet so the user can review the results.

Rules: never overwrite existing non-empty cells; if a field cannot be confidently found for a company, leave that cell blank and do not mark the row Enriched; rerunning the workflow on the same sheet should be safe and only process rows that are still missing data.