/Apps-script-GroupMe-grocery-list-

Pulls responses from group me group and sorts them on to a spreadsheet

Primary LanguageJavaScript

Apps-script-GroupMe-grocery-list-

Pulls responses from group me group and sorts them on to a spreadsheet

Want a fast and easy way for you and your family to collaborate on a grocery list? Is collaborating on a google doc too inconvenient?

With this apps script code users can text an item to their groupme group and have the item immediately added and sorted onto a spreadsheet!

SET UP

  • 1. Upload main.gs to your drive
  • 2. Create a group on groupme
  • 3. Go toGroupMe Bots Developer page and use the form to create a bot.
      For the callback use the URL from the script on your google drive
  • 4. Copy the bot ID and add it to the code
  • 5. Create your spreadsheet and copy its URL into the specified area in the code
  • 6. Run the sendText function and autheticate the scripts.
      If you are having trouble with the bot picking up your messages then try editing the sharing settings of your script and spreadsheet on the drive.