This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import csv | |
import difflib | |
import io | |
import re | |
import requests | |
SHEET_URL = 'https://docs.google.com/spreadsheets/d/1PIVUewR8OE9LHSoEvpH6jEoaDvd3TpH2t3ryZwptxJs/edit#gid=561315341' | |
BRANCHES = ['CSAI', 'CSB', 'CS', 'IT'] | |
if __name__ == '__main__': |
This Google Sheets script fetches data from a Supabase database and writes the selected headers and data to the active sheet. The script first clears the sheet, writes the headers, then fetches the data from the Supabase API, and finally writes the data to the sheet.
- Make sure your Supabase Database RLS policy allows reads (you might need to tweak some RLS policies).
- Create a new Google Sheet or open an existing one.