you're reading...

Make Your Own App using GSheets – #Physed Example


Ever thought it would be really cool to make your own app to make your life easier? It could be something in your social life or even in the classroom?

If you know how to use Google Sheets you can!!

You will need to use an add-on called AppSheet.

So you can see the magic you will need to fill some information out.  I thought it would be a good idea to start a list of #Physed teachers who blog and share information.  I took the first five names from @osama #physedme group that him, Reema and I set up last year.  Add your details so you can see how it works.

Click here

Next you will need to go to the app store or android store to download appsheet.

IOS: Click Here

Android: Click Here

To install the ‘#Physed ‘ app, please click the link below on your mobile device and follow the instructions:

Install the app

You may want to copy and paste the above and send the information to your mobile via email or text message. Follow the instructions, you need to open it in Safari though.

Then VOILA! Anything that gets updated in the google sheet will automatically update on the app and vice – versa.  We can now have a list of #Physed teachers, their contacts and you can look at their blogs all from the same place. GENIUS!

Here is some screen shots from my device:

IMG_7954 IMG_7955

Once you click a teachers name you can access all their information, send them an email or go straight to their blog.

If you realise the data is incorrect you can just click “Edit” and it will automatically change on the google sheet from before as well as the app.

There is so many other apps you could create and this was just a simple one to show people what can be achieved.  More examples can be found here: Click Here


How could you use this in your life? School?

What would you create from a google sheet?


3 thoughts on “Make Your Own App using GSheets – #Physed Example

  1. Great , love it , I was looking to convert my physedmap.com to app

    Posted by Osama Abujafar | November 6, 2015, 8:10 pm
  2. Great idea here – already thinking of lots of uses for this. Thanks for sharing

    Posted by Ben | November 7, 2015, 9:45 am


  1. Pingback: The PE Playbook – October 2015 Edition | drowningintheshallow - November 1, 2015

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: