ChatGPT Learn Logo

πŸ“Š ChatGPT + Google Sheets

Need ChatGPT to analyze, summarize, or generate content directly into your spreadsheets? Here’s how to connect it with Google Sheets.

πŸ“ˆ Why Use It

  • Generate product descriptions in bulk
  • Summarize reviews or feedback in one cell
  • Create auto-responses for email lists
  • Score or rank items based on sentiment

βš™οΈ Integration Tools

  • Google Apps Script (Custom function)
  • Zapier / Make (connect rows to ChatGPT API)
  • SheetAI plugin (if available)

πŸ§ͺ Example Google Script


function GPT(text) {
  const token = 'your-openai-api-key';
  const payload = {
    model: 'gpt-3.5-turbo',
    messages: [{role: 'user', content: text}]
  };

  const response = UrlFetchApp.fetch('https://api.openai.com/v1/chat/completions', {
    method: 'post',
    contentType: 'application/json',
    headers: {
      Authorization: 'Bearer ' + token
    },
    payload: JSON.stringify(payload)
  });

  const result = JSON.parse(response.getContentText());
  return result.choices[0].message.content.trim();
}