Google-sheets – Alternative to a spreadsheet/Google Sheets for distributing one-time-use links

google sheets

I have a list of 1,000+ unique URLs for people to download a custom iPhone app that's on Apple Business Manager. Google Sheets allows everyone with the URL of the sheet to see the list, and they can add an X in the second column when they've claimed the code. Except for one major flaw: it does not allow people to edit if they're using a mobile web browser, and prompts them to install the Sheets app. That's a no-go. So I was looking into alternatives, as in other online spreadsheet applications that do allow the use of a mobile web browser. EtherCalc.net, while functional on desktop, does not have a mobile interface available so that's not an option either.

Is there some way I can send each person one of those unique URLs without needing to spend too many hours doing it manually?

Best Answer

You could use Google Apps Script to deliver an unique URL to each person.

There are several ways to do this,

  1. Send an email
  2. Create a web app

Resources

Related Topic