0

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?

0

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

| improve this answer | |
  • @YAOMTC You are welcome. Please bear in mind that quetions asking for software recommendations are off-topic here but might be on-topic in Software Recommendations (checkout their How to ask guidelines before posting a question) (I mentioned Google Apps Script here because it "included" in Google Sheets) – Rubén Oct 28 at 17:02
  • I thought I would be using a web app for this, but I did not realize Word had this functionality until after I posted the question and started doing more research. – YAOMTC Oct 28 at 17:04
  • @YAOMTC That is fine. – Rubén Oct 28 at 17:04
0

I ended up using the Mailings tab in Word, which can reference a chosen spreadsheet containing email addresses and other data columns, such as Name or in my case URLs. "Insert Merge Fields" is used to insert the URL. It then uses Outlook to send the emails out.

More info: https://support.microsoft.com/en-us/office/use-mail-merge-to-send-bulk-email-messages-0f123521-20ce-4aa8-8b62-ac211dedefa4

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.