Author Copy Codes

Shopify · SendGrid · Google Sheets

Reads 'Shopify listing' tab for Free Author / Free + Global Dist. books with a Shopify link but no code.

Generate Codes for Newly Listed Books

Scans the Google Sheet for Free Author books with a Shopify link but no discount code. Creates codes in Shopify, emails authors, and writes codes back to the sheet.

Update Status for Author Copy Codes

Scans Shopify orders from the last few days for redeemed author-copy codes, then highlights those codes green in the sheet so you can see which have been used.