Cutup Requests with Google Sheets Integration
This web portal serves as a gateway between users and PreSnap when it comes to custom football footage. With this website, users can make requests for specific cutup videos, and once fulfilled, they would receive an automated message linking them to the newly uploaded content.
Stack
- Next.js
- React
- Google APIs
- Supabase
- Axios
- Tailwind
Goal
The purpose of this project was to allow for customers to request cutups of all-22 football film. This tool would come in handy for someone looking to review or study a particular play from a college football game.
Process
PreSnap was looking for an intuitive and collaborative way to review and process the requests submitted by users on the front end. Google Sheets was our best option, so I did some research and figured out a way to get a Google Service API key which I then used to make requests from our site to a Google Sheet document that was shared with myself and the CEO. Each form submission on the front end was written to the Sheet as well as being backed up to the table hosted on Supabase.
Later I added a column to this sheet that upon change, would send an automated email to the user who submitted the initial cutup request, linking them to the uploaded footage on PreSnap's site. The success or failure of the email would then be logged on to the sheet as well for later review.
