Enrich domains with SimilarWeb traffic analytics in Google Sheets & Airtable

How it works This workflow starts whenever a new domain is added to a Google Sheet. It cleans the domain, fetches traffic insights from SimilarWeb, extracts the most relevant metrics, and updates the sheet with enriched data. Optionally, it can also send this information to Airtable for further tracking or analysis.

Step-by-step

Trigger on New Domain

- Workflow starts when a new row is added in the Google Sheet.

- Captures the raw URL/domain entered by the user.

Clean Domain URL

- Strips unnecessary parts like http://, https://, www., and trailing slashes.

- Stores a clean domain format (e.g., example.com) along with the row number.