Airtable Guide for Indie Hackers

For indie hackers, this means you can track users, product ideas, and revenue in a single place while still exporting CSVs for analytics. Airtable also offers native forms, API access, and automation that replace many separate SaaS tools.

Setup & First Base

1. Create an account

Go to airtable.com and sign up with Google or email. The free tier gives you 1,200 records per base and 2 GB of attachment storage.

2. Choose a template

Start with “Product roadmap” or “User feedback”. Templates pre‑define tables, field types, and useful views. Click “Use template” and rename the base to My Startup.

3. Adjust field types

Open the “Ideas” table. Change the “Priority” field from “Single line text” to “Single select” with options Low, Medium, High. This prevents typo errors and makes grouping easier.

4. Set up a primary key

Every table needs a unique identifier. Add a field called “ID” of type “Auto number”. Use this field in API calls to avoid ambiguous lookups.

5. Invite collaborators

Click “Share” → “Invite by email”. Assign “Editor” rights to co‑founders and “Read only” to advisors. Permissions are per‑base, not per‑table, so plan who can edit what.

Core Workflows for Indie Projects

1. Collecting user feedback

• Create a “Feedback” table with fields: Name (single line), Email, Feature request (long text), Status (single select: New, Reviewed, Planned, Done).
• Enable “Form view”. Copy the share link and embed it on your landing page.
• In the “Grid view”, filter Status = New to see fresh submissions.

2. Roadmap planning

• Link “Feedback” to a “Roadmap” table via a “Linked record” field.
• In “Roadmap”, add fields: Quarter (single select), Owner (collaborator), Target date (date).
• Use “Kanban view” grouped by Quarter to visualize upcoming work.

3. Simple CRM

• Table “Leads” with fields: Company, Contact, Stage (single select: Prospect, Contacted, Negotiating, Closed), Value (currency).
• Link each lead to a “Notes” table for meeting logs.
• Create a “Calendar view” based on a “Next contact” date field to schedule outreach.

4. Financial tracking

• Table “Revenue” with fields: Month (date, month granularity), ARR (currency), Churn (percentage).
• Use a “Bar chart” block (free) to see month‑over‑month growth.

Advanced Patterns & Automation

1. Automated email on status change

Open “Automations” → “Create new”. Trigger: “When record matches conditions” → Table “Feedback”, Condition Status = Planned. Action: “Send email”. Fill in subject “Your idea is now on the roadmap” and use {Feature request} as a placeholder.

2. Sync with Stripe

Use the native “Stripe integration” (available on the Plus plan). It pulls new customers into a “Customers” table, updates the “Revenue” table, and triggers a “Slack notification” when MRR passes a threshold.

3. Webhook to trigger a build

When a record in “Roadmap” moves to Status = Done, fire a webhook to your CI/CD pipeline (e.g., Vercel). In the automation, choose “Run a script” and paste:

let table = base.getTable('Roadmap');
let record = await input.recordAsync('Pick a record', table);
await fetch('https://api.vercel.com/v1/integrations/deploy/prj_123', {
  method:'POST',
  headers:{'Authorization':'Bearer YOUR_VERCEL_TOKEN'}
});

Replace the token with a secret stored in a separate “Secrets” table (field type “Password”).

4. Batch updates with scripting

Open “Scripting” block. Example: mark all “Leads” older than 30 days as “Stale”.

let table = base.getTable('Leads');
let query = await table.selectRecordsAsync();
let updates = [];
let now = new Date();
for (let rec of query.records){
  let lastContact = rec.getCellValue('Last contact');
  if (lastContact && (now - new Date(lastContact)) > 30*24*60*60*1000){
    updates.push({id:rec.id, fields:{Stage:'Stale'}});
  }
}
await table.updateRecordsAsync(updates);

Airtable vs. Google Sheets vs. Notion

Common Mistakes & How to Fix Them

1. Over‑typing fields

Changing a field from “Number” to “Single line text” after data entry corrupts formulas. Fix: Add a new correctly typed field, copy values with VALUE(), then delete the old field.

2. Ignoring view permissions

All collaborators see every view. If you need a private “Finance” view, create a separate base and link via sync. This isolates sensitive data.

3. Running out of automation runs

Free plans cap at 100 runs/month. Batch multiple actions into a single script or use Zapier’s free tier for overflow.

4. Not indexing linked records

Large tables (>5k rows) become slow when linking. Add a “Lookup” field that pulls only the needed column, and hide the full linked table in default views.

5. Forgetting to back up

Airtable’s export is manual. Schedule a weekly CSV export using a script that calls the API and saves to a cloud bucket.

FAQ

Do I need a paid Airtable plan to run a startup?

You can start with the free plan. It offers 1,200 records per base and 2 GB attachment space, enough for early prototypes. Upgrade only when you need more records or automation runs.

How does Airtable compare to Google Sheets for relational data?

Airtable lets you link records between tables, create view filters, and attach files directly. Google Sheets can simulate relations with formulas, but it becomes error‑prone at scale.

Can I automate email notifications without Zapier?

Yes. Airtable’s native automation can trigger emails, Slack messages, or webhook calls when a record meets a condition. The free plan allows up to 100 runs per month.

What is the best way to import existing CSV data?

Open a new base, click “Add or import,” choose CSV, and map columns to field types. Clean the data first; Airtable will flag mismatched types during import.

Why do my formulas sometimes return ‘#ERROR!’?

Formulas fail when a referenced field type changes (e.g., a number becomes a single line text). Keep field types stable, or wrap references in VALUE() to force conversion.

Use this guide to get Airtable up and running fast. The tool can handle everything from idea capture to revenue dashboards. Keep your bases tidy, automate repetitive steps, and you’ll spend more time building and less time managing spreadsheets.