Google Apps Script

253 snippets, unlocked with membership.

48 more with membership

Same format: full file, copy button.

Use Random Quote API in Google Sheets

function getQuote(category){
  if (category == 'famous' || category == 'movies'){

Ultimate Prompt Writer and Prompt Rater

function GPT(prompt) {
  var apikey = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("apikey").getRange("A1").getValue();

Ultimate Headline Writer with GPT in SHEETS

/**
 * Generates a response from an OpenAI prompt

Upgrade Google Sheets OpenAI Prompt to GPT 4

function openai(prompt) {
  var apikey = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("apikey").getRange("A1").getValue();