Setup
Google Sheet is the shop ledger. Set it up once on a computer, then open this app on every phone.
This phone
Saving on this phone only
PIN •••••• · other phones cannot see this stock
1. Create the sheet
- 1On a computer, open sheets.new and name it Arifa Telecom.
- 2Menu: Extensions → Apps Script. Delete the starter code.
- 3Paste the script below and click the disk to save. The PIN •••••• is already inside it.
2. Publish it as a web app
- 4In Apps Script: Deploy → New deployment.
- 5Type: Web app. Execute as Me. Who has access: Anyone — not “Anyone with a Google account”.
- 6Click Deploy. Google may say the app isn’t verified: Advanced → Go to Arifa Telecom (unsafe). It is your own script. Click Allow.
- 7Copy the Web app URL. It ends with /exec.
3. Paste the URL
Use “empty sheet” for a real shop start. Use “copy this phone’s stock” if you already typed real items here (not the sample list).
4. Other phones
On the next phone, open this app → Setup, and paste the connection code. Same Google Sheet, same PIN.
Connect a sheet first to get a code.
This phone only
Fine for trying the app. Stock will not follow him to a second phone until the sheet is connected.
Backup file
Download JSON you can restore later, or open in a text editor.