Skip to content

Instantly share code, notes, and snippets.

View keccers's full-sized avatar

Katherine Champagne keccers

View GitHub Profile
@keccers
keccers / postcalendar.js
Created July 29, 2019 21:43
Google Calendar x Google Sheets AppScript Plugin
function updateEvents() {
// Get Sheet and Calendar
var spreadsheet = SpreadsheetApp.getActiveSheet();
var postCal = CalendarApp.getCalendarById('talentinc.com_hq7sgaqvp5kjgu7a865n4j91tc@group.calendar.google.com');
// Get data from Sheet
var data = spreadsheet.getDataRange().getValues()
var posts = []
@keccers
keccers / gist:fdb80916c9697079d0626723a2b22e2b
Last active March 23, 2025 04:15
Google Sheets Scheduler for Farcaster
/**
* Warpcast Scheduler for Google Sheets
*
* This script polls a Google Sheet and schedules posts to be sent via an API
* at the times specified in the "Post Time" column.
*/
// Configuration
const API_URL = 'MY API URL';
const API_KEY = PropertiesService.getScriptProperties().getProperty('APIKey');