ComfySheets The Comfiest Way to Read from Google Sheets and Submit to Google Forms
We built this module for easily submitting to Google Forms and reading from Google Sheets live on Twitch for the Coding Cafe!
Like these projects? The best way to support my open-source projects is by becoming a Comfy Sponsor on GitHub!
Come and hang out with us at the Comfiest Corner on Twitch!
Based on https://ben.page/google-sheets-json
- The first row of your spreadsheet should be headers, and the rest is data under those headers (see example).
- Share the spreadsheet so anyone can see it (“Share” button in top right corner > “Anyone on the internet with this link can view”).
- Take the sheetId part of the URL like
1rGWoJd4utybt1wNPAWVrYmjnNKgSkQ_8nTd-54QtfGMpart of the link https://docs.google.com/spreadsheets/d/1rGWoJd4utybt1wNPAWVrYmjnNKgSkQ_8nTd-54QtfGM/edit and then use that as the SheetID inComfySheets.Read()
Thank you too all the participants of this project!
Special thanks to CarstenPet for helping us migrate to Google Sheet v4
Instafluff, Instafriend, ChatTranslator, That_MS_Gamer, guthron, Alca, liopleurodonic, sparky_pugwash, BungalowGlow, Spationaute, amlan77, eateren, Linol_Shadowcat, where_is_laughingman, ecomath328, yumimilk, Agent_Merlin, LastLeap, LilyHazel, FuriousFur, Patchshifter, simrose4u, Shaezonai, Gilokk0, EnesOzdemirTV, KappaMangos, losthewar, MalForTheWin, atel0s, RIKACHET, wabes1, opti_21, AntiPixelated, Apollodoro5, rockysenpai24, DutchGamer46, SausageCam, sethorizer, SourBeers, mcgeorgeofthejungle, aj2017, doppioTV, cotoli, elsuxo, Chibigirl24, CrimsonKnightZero, DragosNox, holloway87, BEN_THE_CAT_GUY, 10TenArt, Underground_Violet_Doggo, GrigNutHugger, MaryJoStaebler, roberttables, xcrazykitty, CaspiusLabs, DoctorArgus, wietlol, Nordegraf, codeaurora, lilsafbig, merkurrz, Songfox, Outlaw_Dan, SoG_Cuicui, phrakberg, pwrdwnsys, JesseSkinner, Wasabi_Cheetah, MisterHex, atd285, IntellectDevourer, RikuRinku, LuckyNoS7evin, BaconBastrd, kinbiko