Send an email with google spreadsheet automatically for a purchase

Technical Q&A

Topic summary

A user seeks to automatically send an email containing a Google Spreadsheet link when customers purchase a free product from their online store.

Proposed Solution:

  • Customize the order confirmation email template
  • Add conditional logic to detect when the order contains the specific free product
  • Include the Google Spreadsheet link at the bottom of the template for qualifying orders

Status: The question remains open with one suggested approach provided, but no confirmation of implementation or alternative solutions discussed.

Summarized with AI on November 8. AI used: claude-sonnet-4-5-20250929.
1

Hello, How can I set up an automatic email to be sent out containing a link to a Google Spreadsheet that is sent out when a customer purchases a free product? Here is the link to the product for which I would like the email to be sent out: https://brewbarncoffee.com/products/lactose-free-products-list

2

Hi @N4th4nsgt ,

You can customize the order template to check if order contains free product and add link at the bottom of the template which will have the spreadsheet link.