DropForm - Any Webhook to Google Sheets in 90 Seconds

Zapier charges $50/month and still requires 12 clicks to get a webhook into Google Sheets. DropForm gives you a unique webhook URL, a column-mapping UI, and live data in your sheet in under 90 seconds. One job, done perfectly, priced like a coffee.

𝕏 Post Reddit HN

Difficulty

beginner

What is it?

Thousands of indie hackers, small ops teams, and solo founders need to pipe webhook data into Google Sheets for reporting, monitoring, or simple dashboards — but Zapier is overkill and too expensive for single-use automations. DropForm generates a unique inbound webhook URL, auto-detects the payload schema on first hit, lets the user drag-drop which fields map to which columns, and writes rows to Google Sheets in real time via the Sheets API. No Zapier account, no n8n self-hosting headache, no code. Target market is 500,000 indie hackers and small ops teams on r/indiehackers and r/nocode actively complaining about Zapier pricing. Buildable in one weekend using Next.js API routes as webhook receivers, Google Sheets API for writes, and Supabase to store mapping configs.

Why now?

Zapier raised prices again in early 2026 and r/nocode is full of users actively seeking cheaper single-purpose alternatives — this is the exact moment to capture the migration wave.

▸Auto-detect JSON payload schema and suggest column mappings on first webhook hit
▸Drag-and-drop field-to-column mapper with nested JSON path support
▸Live webhook log showing last 20 hits with payload preview and row write status
▸One-click Google Sheets OAuth connection with sheet and tab selector

Target Audience

Indie hackers and small ops teams (1-5 people) who need one-way webhook-to-Sheets pipelines without Zapier overhead, approximately 500,000 active users in no-code communities.

Example Use Case

Sam runs a micro-SaaS and wants every new Stripe webhook event logged to a Google Sheet for his weekly revenue review. He sets up DropForm in 90 seconds, maps 5 fields, and his sheet auto-populates without touching Zapier or writing a line of code.

User Stories

▸As an indie hacker, I want to pipe Stripe webhook events into Google Sheets, so that I have a live revenue log without Zapier.
▸As a small ops manager, I want to map nested JSON fields to specific columns, so that my Sheet stays organized without manual reformatting.
▸As a free user, I want an email warning when I approach my 500-row limit, so that I can upgrade before my pipeline breaks.

Acceptance Criteria

Webhook Receiver: done when a POST to the unique URL writes a row to the connected Sheet within 3 seconds. Schema Detection: done when first payload hit auto-populates field mapper with correct key names. Google OAuth: done when user can connect a Sheet and select a tab without touching code. Row Limit Gate: done when free users are blocked at 501 rows and shown an upgrade prompt.

Is it worth building?

Free tier: 500 rows/month. $9/month for 10,000 rows. $29/month for 100,000 rows. Assuming 300 paid users at blended $12/month = $3,600 MRR at month 4.

Unit Economics

CAC: $3 via organic Reddit and SEO. LTV: $216 (24 months at $9/month average). Payback: immediate. Gross margin: 94%.

Business Model

Freemium with usage-based upgrade

Monetization Path

Free tier converts at 8% when users hit 500-row limit. Upgrade triggered by hitting limit mid-month.

Revenue Timeline

First dollar: week 2 via limit upgrade. $1k MRR: month 2. $5k MRR: month 8.

Estimated Monthly Cost

Vercel: $20, Supabase: $25, Google Sheets API: free, Stripe fees: $15, Resend: $10. Total: ~$70/month at launch.

Profit Potential

Lifestyle business at $3k-$8k MRR. High churn risk if Zapier drops pricing.

Scalability

Medium — add multi-sheet routing, Airtable destination, scheduled batch flush for high-volume senders.

Success Metrics

Week 1: 200 signups. Week 2: 30 active webhooks. Month 1: 25 paid users.

Launch & Validation Plan

Post in r/nocode and r/indiehackers asking how people get webhooks into Sheets. If 20+ upvotes on the pain, build it that week.

Customer Acquisition Strategy

First customer: post a 60-second demo video in r/indiehackers showing the 90-second setup flow. Ongoing: SEO targeting 'webhook to google sheets', ProductHunt launch, Twitter/X no-code community posts, Make and Zapier subreddit community presence.

What's the competition?

Competition Level

Medium

What's the roadmap?

Feature Roadmap

V1 (launch): webhook receiver, schema detection, field mapper, Google Sheets write, Stripe metered billing. V2 (month 2-3): webhook filtering by field value, multi-tab routing, CSV export of event log. V3 (month 4+): Airtable destination, team accounts, usage analytics dashboard.

Milestone Plan

Phase 1 (Week 1): webhook receiver, schema detection, Sheets OAuth, field mapper — done when test payload appears in real Sheet. Phase 2 (Week 2): Stripe billing, dashboard, event log — done when free limit gate works. Phase 3 (Month 2): SEO pages live, ProductHunt launch, 25 paying users.

How do you build it?

Tech Stack

Next.js, Google Sheets API, Supabase, Stripe, Resend — build with Cursor for webhook receiver logic, Lovable for mapping UI, v0 for landing page.

Suggested Frameworks

Time to Ship

1 week

Required Skills

Next.js API routes, Google Sheets API OAuth, Supabase, Stripe.

Resources

Google Sheets API docs, Supabase quickstart, Stripe metered billing docs, Next.js API routes docs.

MVP Scope

pages/index.tsx, pages/dashboard.tsx, pages/endpoint/[id].tsx, api/webhook/[id].ts (receiver), api/sheets/connect.ts, api/sheets/write.ts, lib/supabase.ts, lib/sheetsClient.ts, supabase/schema.sql, vercel.json.

Core User Journey

Generate webhook URL -> send first test hit -> auto-detect schema -> map fields to columns -> connect Google Sheet -> live rows appear in 90 seconds.

Architecture Pattern

Unique webhook URL hit -> Next.js API route receives payload -> schema auto-detected and stored in Supabase -> field mapping applied -> Google Sheets API writes row -> row count incremented for billing.

Data Model

User has many Endpoints. Endpoint has one FieldMapping and one SheetConnection. Endpoint has many WebhookEvents. WebhookEvent has payload JSON, status, and timestamp. User has one UsageCounter.

Integration Points

Google Sheets API for row writes, Supabase for endpoint config and row count, Stripe for metered billing, Resend for limit warning emails, Vercel for webhook receiver hosting.

V1 Scope Boundaries

V1 excludes: Airtable destination, Notion destination, two-way sync, scheduled polling, team accounts, webhook filtering/transformation logic.

Success Definition

A non-technical founder sets up a webhook endpoint, maps fields to columns, and has live data in their Google Sheet without any founder help or documentation reading.

Challenges

Zapier or Make could add a one-click competitor feature overnight — the moat is simplicity and price, not technology. Charge before users realize they could build this with Apps Script.

Avoid These Pitfalls

Do not support Airtable or Notion destinations in V1 — scope creep kills the 1-week ship. Google OAuth app verification takes up to a week — start it on day one of building. Finding first 10 paying users requires a live demo video, not just a landing page description.

Security Requirements

Supabase Auth with Google OAuth. RLS on endpoints table by user_id. Webhook URLs use UUID v4 (unguessable). Rate limit: 1,000 hits/hour per endpoint. GDPR: payload data purged after 30 days.

Infrastructure Plan

Vercel for Next.js (serverless webhook receiver scales automatically), Supabase for Postgres, GitHub Actions for CI, Sentry for errors, Vercel Analytics for traffic. Total: ~$70/month.

Performance Targets

500 DAU at launch, 50,000 webhook hits/day. Row write to Sheets under 2s. Dashboard load under 1.5s. Vercel serverless auto-scales — no manual caching needed at launch.

Go-Live Checklist

☐Google OAuth app verified
☐Stripe metered billing tested end-to-end
☐Sentry live
☐Webhook receiver load tested at 100 concurrent hits
☐Custom domain with SSL
☐Privacy policy published
☐5 beta users confirmed rows appear correctly
☐Rollback plan documented
☐Reddit and ProductHunt launch posts drafted.

How to build it, step by step

1. Scaffold Next.js app and install @supabase/supabase-js and googleapis. 2. Create Supabase tables for endpoints, field_mappings, and webhook_events. 3. Write Next.js dynamic API route api/webhook/[id].ts that receives POST payloads and stores them. 4. Write schema auto-detection utility that flattens nested JSON and suggests column names. 5. Build drag-and-drop field mapper UI with react-beautiful-dnd. 6. Implement Google Sheets OAuth flow and store refresh token in Supabase. 7. Write Sheets API row writer that applies stored field mappings. 8. Build dashboard page showing endpoints, live event log, and row count. 9. Add Stripe metered billing that increments on each row write and gates at 500 free rows. 10. Deploy to Vercel and test with a real Stripe webhook payload.

Generated

April 14, 2026

Model

claude-sonnet-4-6

← Previous

SprintCast - Async Standup Bot That Actually Surfaces Blockers

PitchVault MCP - Live Investor Portfolio and Thesis Context Server for Claude and Cursor

Disclaimer: Ideas on this site are AI-generated and may contain inaccuracies. Revenue estimates, market demand figures, and financial projections are illustrative assumptions only — not financial advice. Do your own research before making any business or investment decisions. Technology availability, pricing, and market conditions change rapidly; always verify details independently.