Google Sheets? Airtable? MySQL?


In "digital marketing world" it's very common to use Google Sheets to store data. Ex:

→ Metrics from Facebook Ads → Google Sheets → Google Data Studio
→ Metrics from Google Ads → Google Sheets
→ Metrics from ActiveCampaign → Google Sheets → Google Data Studio

Google Sheets is not a database. The performance slows down after many rows.

In your opinion: Which is the best option to store data and integrate with other services by using Zapier, Integromat, etc.... ? I like Airtable... Suggestions?


#Google Sheets #Airtable #Database #Data #Marketing #Analytics #Spreadsheets #ActiveCampaign #Integromat #Metabase
ambar_tayde's avatar
almost 2 years ago

Hey, I have used Airtable as a database for an Admin Panel and Dashboard. And it worked out pretty well, because it is easy to integrate. I have integrated it with my app in made on DronaHQ (low-code platform).

Check it out >

4 points
shannonratliff's avatar
almost 2 years ago

I love Airtable, the single-select field is game-changing for grouping items together by category to see more specific stat breakdowns. Charts and pivot tables are exceptionally easy to put together once you get the basic organization you want to create down. I've organized an article archive database of 50,000+ on Airtable, and have built channel/platform stat burndowns and analytical databases before. I love how no-code/low-code Airtable is, it's inspired me to get a little better without feeling forced into it. I'm an Airtable fangirl.

There is a small learning curve that can feel scary when onboarding teams, but it's more about feeling confident in knowing you can't really break anything if you make a copy, ha!

4 points
sandbui's avatar
almost 2 years ago

How much data do you need to store? Google Sheets is basically an online spreadsheet that can only take you so far. If you want to take it a step further, then Airtable is a good option as it's a spreadsheet-database hybrid.

However, if you want to query your data and find insights. Then you'll need to upgrade to a data warehouse like Redshift, Snowflake, Google BigQuery, etc. You'll have to use a BI tool like PowerBI, Tableau, Thoughtspot, Sisense, etc to then query the data to create visualizations and give you insights into how your marketing campaigns are performing.

A number of integration tools like Zapier, Integromat and can help integrating and connecting the different tools that you use in your stack.

3 points
navpar's avatar
almost 2 years ago

Hosted MySQL + Metabase (either self hosted , maybe via, or SaaS). I believe it is easier than most people think

1 point
landonray's avatar
almost 2 years ago

Airtable's amazing of course, but also has very low limits for data.. much lower than Sheets. 50k or 100k per base I think?

1 point
maguay's avatar
@maguay (replying to @landonray )
a year ago

Airtable's database sizes are partly limited by plans—free plans get 1,200 records per base, Plus plans get 5k records, and Pro plans get 50k records per base—and are capped at a max of 100k records per base.

Google Sheets today can handle a max of 5 million cells per spreadsheet, with up to 18,278 columns.

Excel can handle up to just over 3x that, with modern Excel files capped at 1,048,576 rows by 16,384 columns.

Beyond that—and honestly, long before that—you'll be better served by a dedicated database.

1 point
Any suggestions for a workaround to an Outlook calendar not syncing with Google Calendars?

Google lets you subscribe to a calendar using a URL - although when using an Outlook 365 Calendar link, events are copied over once, and then the syncing stops. This seems to be a relatively new is...

What's the best video conferencing app for internal discussions?

Three major considerations I have been using to evaluate the plethora of options available: 1. Effortless/non-intrusive: It shouldn't feel like a video call 2. Price: As this app would be complime...

Confluence alternatives for wiki/knowledge bases?

I've been looking to try something new for knowledge/documentation storage for a little while now. Confluence has always been there, but I find it to be relativly limited for the cost and additiona...

The community for power users.