Build & run an entire agency

Explore

We built PubLoft (marketing for startups) to $300,000/year using only Airtable, Zapier, Typeform, and Weebly.

ā€‹

The biggest advice I can give anyone building a business on Airtable: start small, but separate every variable into its own table. For example, we started by describing the assignment ā€œtypeā€ as simple text, until we decided to create a table for Deliverables to organize our offerings and pass pricing information through Zapier.

ā€‹

Since July 2018, PubLoftā€™s freelance content strategists, writers, and editors have used a Weebly portal with embedded Typeforms + Airtables to create, claim, and submit assignments in/out of our system.

ā€‹

Our Zapier automation glues everything together, from initial client requests to finalized pieces sent for approval.

Explore
Updated February 16, 2021 at 6:59 PM
Copied 211 times

JƩrƩmy Chevallier

GigLoft Cofounder & CMO ā€¢ dedicated to helping creative entrepreneurs pursue their craft full-time šŸš€
Explore the base
All Clusters
PuubLoft
All Topics (Internal Master View)
Production Calendar
All Topics (Kanban)
Client-Specific View
New Requests and Ideas
All Used Keywords
Empty keywords
All Posts (Master view)
PubLoft Press Schedule
Todayā€™s Posts
Next Weekā€™s Posts
Following Weekā€™s Posts
Post Grading & Rating
Up For Grabs! (Tier 1)
Up For Grabs! (Lite posts)
Offered to Writer
Offered to Writer OR Up For Grabs (Champ portal)
Queued Up
All Posts Up For Grabs
All Posts In Production (Tier 1) (being Written or edited)
Deadline is 48 hours away
Deadline is 24 hours away
All Posts Being Written
All Posts In Revisions
All Posts In Production (DIY)
All Posts In Production (Int. View)
Posts Written, Ready to Edit
Posts Being Edited, Ready to Resubmit
Editor Feedback to Writers
Approved & Ready to Send
Approved & Ready to Send NEW
This Week's Posts
Next Month's Posts
Individual writer view
Client-Specific View
Pay Day View
Past Payments
Scores
Publish & Track View
Published, not Tracked
All Customers (Internal View)
All Clients (Internal View) Nisreen
Parlay Ideas
All Keywords with Topic
All Keywords Already Used
Posts ā€œReady to Sendā€ to PWN
All Available Keywords
Mat's View!!
All Potential Keywords
New Keywords (need metrics)
All Posts Up For Grabs
CBD For Life
The Wayne Smith
SafetyTek
SceneDoc
Codility
Inflect
Apptimize
PubLoft
EvaBot
Roofr
Stream
Jump Ramp Games
All Used Keywords
temp master view
Empty keywords
All Current Customers
Active Paying Freelancers
All Customers Addresses
Integrations
Developer View
Customer Success
Active Payment Calendar
Active Recurring Financials
Active Recurring Financials - Mat
ALL Customer Financials
Trials
Emails
All Customers Ever
Onboard Dates
PubLoft for Startups
AutoPublish Customers
Not AutoPublish Customers
Customers by Sector
Startups
Production Cycle [not accuratee formulas]
Inflect
SafetyTek
EvaBot
Apptimize
Codility
CBD For Life
Roofr
Temp mailchimp
Non DIY Customers
Grid 26
Mats testing ground
Dave School's View
John's View
Customer Sign up Date
Churned customers
LTV Calculator
Customer Metric Dash - Mat
Grid 42
Jeremyā€™s Master View: All People
Designers
Battle-Ready Designers
Developers
Designer
Wordpress Devs (ext. view)
Reviewing Applicants
Approved for Vetting/Paid
Gallery
Kanban
Active, Vetted Writers
Eligible Writers (Weebly Champ portal)
Other Languages
Video industry writers
Spanish Language Writers
Hindi Writers
English Only
Technical Writers
Writers Approved For Vetting
Topic: Business Writers
Leaderboard formulas
Writer Leaderboard!
Editor Leaderboard!
Pay Day View
Quest Player Board
Application Dates
Recruiting
Late Calculations
Good Quotes
Running applicant list
Running applicant list (not labeled)
Active Freelancers (not new)
Send Freelancers 2nd Email
Top Writer Applicants
GigLoft_All Candidates
[OLD] [NOT CONNECTED] Funnel for GigLoft
Sent 1st Form_GigLoft
any writer whoā€™s ever gotten work
Follow Up_GIgLoft
GigLoftU_emailTracking
GigLoft U ā€¢ Send offer email!
Testing ground
All Publications
OptimumHQ
Lucktastic (Jump Ramp Games)
Inflect
Stream
Planet 13
Oden Technologies
Carnegie Technologies
CBD For Life
NEW Master Backlink Table
OLD Master Backlink Table
Master view
Grid view
All
Master view
Customer Count