About the Spreadsheet Magic ✨ category

This category is for anyone to chat about more advanced topics relating to Google Sheets, formulas, app script, automation etc…

2 Likes

1 Like

Hi all - is it possible to run an App Script program when someone say ‘clicks a button’ in a Glide App? What I’m thinking is potentially to:

  1. Trigger an email based on an action
  2. Call an API to fetch specific information post a form fill.

Maybe this is a crazy idea but keen to learn more.

How can the user data that has been submitted to the form and entered into the Google form sheet be automatically entered into the new sheet … ?? I use the IMPORTRANGE formula but it doesn’t work … if this can be it is very good for the list method to be a Seller in the marketplace