You are helping me build the following AI agent workflow.

## Goal
Summarize Social Media Posts to Google Sheets: New social posts trigger AI summaries saved directly to your Google Sheet for quick skimming.

## Specification
- What it does: Get a quick overview of your social media activity without manually reading every post: the system detects new messages, summarizes their content using AI, and saves the results in Google Sheets. You can then skim through these summaries to stay informed efficiently.
- Trigger: Triggered by an event (Event · on new social message)
- Autonomy: Fully hands-off
- Expected setup effort: under an hour
- Tools/services involved:
  - Social Media Platform: detects new posts
  - LLM: summarizes post content
  - Google Sheets: stores summaries for quick review

## Known pitfalls, handle each one explicitly in your implementation
1. Long posts may exceed context windows, so truncate input text to a fixed length before sending it to the model.
2. Special characters in social media content can break CSV formatting, escape quotes and commas in the final sheet row.
3. Latency spikes during peak hours might delay updates, implement a retry queue for messages that fail the first attempt.

## Reference implementation
https://www.youtube.com/watch?v=l0SiFihbetA (workflow template)
Fetch and inspect this before building. If it matches my stack, adapt it;
if not, rebuild the pattern with my tools.

## Process requirements
1. Before building: ask me which of the listed tools I actually use and
   what my platform is (n8n / Make / code / other). Do not assume.
2. Adapt the pattern to my answers; do not force the reference stack.
3. Address every pitfall above; tell me how you handled each.
4. Provide a test plan I can run before letting this touch real data.
5. Ask before any step that sends messages, modifies data, or spends money.

Source: https://usecasesforagents.com/use-case/summarize-social-media-posts-to-google-sheets/ via usecasesforagents.com