# Blog: Connect the Website Scraper API to Google Sheets & Airtable

**URL:** `/blogs/guides/connect-website-scraper-api-google-sheets-airtable/`  
**Series:** Website Scraper Playbook — Supporting Guide #3  
**Pillar:** [Extract Emails & Social Profiles at Scale](/blogs/guides/extract-emails-social-links-website-scraper-api/)

---

## Purpose

Shows three concrete integration methods for getting scraped data into spreadsheets/databases without building a backend: Apps Script, Make.com, and n8n. Targets non-developers who want self-updating lead bases.

## Content Structure

1. **Problem** — Manual CSV download cycles create stale data and human error
2. **Education** — Three automation approaches compared (complexity, trigger style)
3. **Implementation** — Full code for each method
4. **Bolt Scraper Example** — Apps Script: `enrichUrls()`, Make.com: 5-step scenario, n8n: 4-node workflow
5. **Docs link** — API jobs & results reference
6. **CTA** — Free trial

## Three Methods Covered

| Method | Code Required | Trigger | Suitable For |
|---|---|---|---|
| Google Apps Script | Low (JavaScript) | Manual button or timed | Sheets users |
| Make.com | None | Webhook (automated callback on completion) | Sheets + Airtable drag-and-drop |
| n8n | Low | Webhook (automated callback on completion) | Self-hosted teams, full control |

## Apps Script Limitations

- Free Gmail accounts: 6-minute execution limit
- Google Workspace accounts: up to 30 minutes
- For lists > ~300 URLs: recommend Make.com or n8n webhook approach

## n8n Airtable Upsert

The Airtable node uses `upsert` on the `Website` match field — existing records update instead of duplicating on re-enrichment.

## Language Rules

- ✅ "automated webhook callback" in Make.com/n8n sections
- ❌ "instant" webhook delivery implied
- ❌ Real company names in code examples
- Code uses `enrichUrls()`, field names `email_1`, `phone_1`, `linkedin_url`, `instagram_url`, `facebook_url`, `page_title`

## Cross-links Out

- [Pillar guide](/blogs/guides/extract-emails-social-links-website-scraper-api/)
- [Webhooks guide](/blogs/guides/website-scraper-webhooks-guide/)
- [Lead enrichment guide](/blogs/guides/enrich-lead-lists-website-scraper-api/)
- [Competitor monitoring](/blogs/guides/competitor-website-monitoring-scraper-api/)

## Last Audited

2026-09-19 — Inline `border-left` styles removed; head structure aligned with pillar blog (GTM, section comments); FAQPage LD+JSON schema added; "verified" language removed.