google sheets to links page

I really wanted a page to share the fun links I come across and couldn't find anything I liked so made this.

Built with: NextJS, FontAwesome, Google Sheets, Github Pages, and designed with Figma.

Demo: https://links.dean.lol

Fork this and make it your own

1. Fork/clone this project (git clone)
2. cd into the project and download the node modules with npm i
3. Rename .envTEMPLATE to .env

Setup the Google Sheet

1. Make a copy of this google sheet
2. In the settings select File > Publish to Web > select .CSV

Connect the Google Sheet

1. Copy the google sheet published link from the last step and paste the URL in .env after URL=. (No spaces, no commas, no quotations.)
2. save and run npm run dev to test.

Make your own website

1. In the package.json you can see the deploy script. Change links.dean.lol to your personal domain.

"deploy": "npm run build && echo links.dean.lol > docs/CNAME && git add -A && git commit -m 'update' && git push",

2. Check out how to point your domain DNS towards github pages, I personally prefer using cloudflare.
3. Upload your repository to your own github, click settings and enable domains.

Confused? Watch me make this site from design to deployment.