Use Dynamic Tags in Prompts

You can make GPT formulas more flexible and data-driven by using cell references inside your prompts. This technique allows your AI responses to adapt dynamically based on the content in your spreadsheet, ideal for generating personalised outputs at scale.

Examples:

• Write custom emails based on customer feedback in each row
  • =GPT("Write a thank-you email for this review: " & B2)
• Generate responses with formatted dates
  • =GPT("Prepare a meeting summary for " & TEXT(C2, "MMMM d, yyyy"))
• Create dynamic prompt lists
  • =GPTLIST("List 5 marketing ideas for the product: " & D2)

tip

This method is especially useful when working with large datasets; one formula can adapt to hundreds of rows without manual edits.