Automation Demo

Survey Outreach Automation

Fill out the customer satisfaction survey below. On submission, Tally pushes the response to a Google Sheet. A Google Apps Script trigger fires, pulls the answers, sends them to Gemini with a custom tone prompt, and emails the AI-drafted reply from my inbox — automatically.

The tone prompt and column mapping live in a single CONFIG The tone prompt and column mapping live in a single CONFIG object at the top of the script — edit those two things and you’re done. No servers, no deployments, no dependencies.

Try It

Responses are real. You'll receive an AI-drafted reply from my email shortly after submitting.

Video Walkthrough

A step-by-step setup guide covering the Tally → Google Sheets connection, pasting the script, setting up the trigger, and grabbing your Gemini API key.

Video walkthrough — coming soon

The Code

Copy the script below, paste it into your Google Sheet's Apps Script editor (Extensions → Apps Script), update the CONFIG block at the top, then add a trigger on processLatestRow to run on form submit. That's it.

Google Apps Script · 129 lines

// ==========================================
// CONFIGURATION
// ==========================================
const CONFIG = {
  GEMINI_API_KEY: 'Insert Gemini Key Here',
  SHEET_NAME: 'Sheet1',

  // Column Mapping
  FIRST_NAME_COLUMN: 'D',      // Submitter's first name
  EMAIL_COLUMN: 'E',           // Submitter's email address
  START_DATA_COLUMN: 'F',      // Start of survey Q&A
  END_DATA_COLUMN: 'K',        // End of survey Q&A
  LLM_RESPONSE_COLUMN: 'L',    // Where the LLM response is recorded

  EMAIL_SUBJECT: 'Thank you for your feedback!',

  // Directives for the LLM to write the full email
  SYSTEM_INSTRUCTION: 'You are an expert Customer Experience leader. Write a complete, ready-to-send email reply directly to the customer based on their survey responses. Use a professional, empathetic, and actionable tone. Start directly with the greeting (e.g., "Hi [Name],") and sign off exactly like this:\n[Your Name]\n[Your Title]\n\nDo not include placeholder text or subject lines in your output. Never use em dashes (-) as they do not sound organic and human.'
};