Birch & Link Co. — Loyalty Rewards

Google Sheets integration

Connect a Google Sheet so your data syncs across all devices. See the setup guide below for step-by-step instructions.

Google Sheet ID

Google Apps Script Web App URL

Change admin password

New password

Quick setup guide

Open Google Sheets and create a new blank spreadsheet
Name row 1 headers: id, name, contact, punches, freeEarned, partyCredits, friendCredits, history
Copy the Sheet ID from the URL (the long string between /d/ and /edit)
Open Extensions → Apps Script in your sheet
Paste the Apps Script code from the google-apps-script.js file included with this app
Click Deploy → New deployment → Web app, set access to "Anyone"
Copy the web app URL and paste both values above

Birch & Link