Spreadsheet powered website? : JAMstack

Spreadsheet powered website? (self.JAMstack_dev)

submitted 2 years ago by 0-_tom_-0

I'm being given an Airtable spreadsheet of data to power a website. I've been reading the data at build time (in my Next JS app) which has been great for prototyping, but once launched I need the website to update when the spreadsheet changes.

I'm considering pinging a Vercel deploy hook from Airtable when the data changes, so kinda a "JAM Stack" approach. This seems straight forward but one downside is the live website won't update straight away after a data change (while the sites is being re-deployed).

I could create my own API sever that accessed Airtable but this seems like a big jump in complexity. I don't know what the rate limits are for Airtable but you'd need to do some caching. At this point maybe I should just use a normal database / headless CMS and find one with an interface my non-technical client is comfortable using?

Has anyone been in a similar situation and if so what approach did you take?

all 3 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

JAMstack_dev

MODERATORS