Operation Olive Branch: Data Extraction
If you've reached this page, you're probably interested in obtaining a .CSV export of Operation Olive Branch's Master List. It's possible, but requires a little technological bravery. Read on to learn more.
Important: The OOB Google Sheet is protected and can't be accessed via standard CSV export URLs. You'll need to download
this script and use the Google Sheets API with a personal API key.
Is this safe?
It's always smart to ask! In general, you shouldn't run scripts you aren't confident in. Full disclosure: I vibe coded this and haven't been through it line by line yet. If you would like to examine the script before you run it, please feel free. If you notice anything weird, please reach out to me on Tumblr and let me know.
Instructions
- Get a Google Sheets API Key:
- Go to Google Cloud Console
- Create a new project or select existing one
- Enable the Google Sheets API
- Create credentials (API Key)
- Edit the Script:
- Right-click the downloaded script
- Open with Notepad++ or any text editor
- Find line 4:
const apiKey = 'YOUR_API_KEY_HERE';
- Replace YOUR_API_KEY_HERE with your actual API key
- Run the Script:
- Make sure you have Bun installed
- Open Terminal and navigate to where the script is
- Run:
bun extract_oob_dot.js
The script will:
- Connect to the OOB Google Sheet via API
- Extract data from the "Master List." tab (with dot)
- Process and clean the data (removing line breaks)
- Save as a .CSV file with today's date
- Store the file in the same folder where the script was run
Make sense?
If you encounter problems, feel free to hit me up on Tumblr and tell me what you're struggling with. I'll do my best to help. We're all in this together, and you wouldn't be trying this without good reason.
Home | Free Palestine!