AppsScriptPulse

Solutions, App Maker

Create a game web-app fast with Google App Maker ? Challenge accepted.

Tags:
| | 0 Comments |

Google App Maker allow you to create responsive web-app fast in your company. What about create an internal challenge ?

In this post Jérémy Dessalines highlights the benefits of using Google App Maker to rapidly develop a web based game and all in a couple of lines of code:

The app benefits from Google App Maker to authenticate the user, create a responsive application that allows the visualization of good practices in the form of cards. … Access is secure and restricted to a small group of users via a Google Group.

Source: Create a game web-app fast with Google App Maker ? Challenge accepted.

Solutions

Google Apps Script — AirTable API – Urwa Shabir – Medium

Tags:
| | 0 Comments |

Just putting it out there for some one who forgets syntax of RESTful API call in Google Apps Script.EVERY.SINGLE.TIME. This one is for AirTable API

I’ve not come across AirTable before but it looks like a nice service for creating database interfaces and in this post Urwa Shabir covers how you can access the AirTable API.

Source: Google Apps Script — AirTable API – Urwa Shabir – Medium

Solutions, Sheets

Accessing Cloud SQL from AppsScript to plot data from IoT Core

Tags:
| | 0 Comments |

In my last post, I wrote about publishing device telemetry from Cloud IoT Core to Cloud SQL. The natural thing to want to do after this is to plot that data and I have found using Apps Script with Google Sheets to be a great way to get this working quickly.

In this post you’ll find some helpful advice on connecting to Google Cloud SQL server with Google Apps Script.

Source: Accessing Cloud SQL from AppsScript to plot data from IoT Core

Add-on, Solutions, Docs

Use Google Apps Script to Securely Share Google Docs

Tags:
| | 0 Comments |

It actually is really easy to add the Virtru SDK to your project, as I’ll demonstrate through the construction of a “Protect & Share” Google Docs add-on.

I’m not familiar with Virtru but in this post from Trevor Foskett (Senior Solutions Engineer at Virtru) shows how their product can easily be integrated into Google Docs as an add-on. You’ll hopefully find this post useful to find out about Virtru as well as how client side and server side processing can be handled using Google Apps Script.

Source: Use Google Apps Script to Securely Share Google Docs

Solutions

Google Apps Script & IoT

Tags:
| | 0 Comments |

Google Apps Scripts are very powerful yet relatively unknown. In this post Fran Galarza shows us what we can do with them & IoT as a use case.

You could have a sensor regularly measuring the humidity of your garden’s soil and posting that value to your GAS (yes, you can make POST requests). Then your GAS could log that measurement in a Google Sheet and send you an email if the soil is too dry. It can even set an event in your calendar to remind you to water your garden.

Source: Google Apps Script & IoT

Solutions, Sheets

Google Script Automation: Create New Sheets Tabs Automatically

Tags:
| | 0 Comments |

Take it off your weekly to-do list — learn how to automatically create a new tab, clear a designated range, and delete an old tab in Google Sheets.

Source: Google Script Automation: Create New Sheets Tabs Automatically

Solutions, App Maker

How to design advanced Google App Maker apps with BigQuery API, Google Groups, Google Data Studio and Cloud SQL

Tags:
| | 0 Comments |

Where should I store my data? Should I sync Cloud SQL and Big Query? How to publish my app,… Read on Jérémy Dessalines’s (@Gr3m) thoughts on working with App Maker.

Source: How to design advanced Google App Maker apps with BigQuery API, Google Groups, Google Data Studio and Cloud SQL

Solutions, Docs

Send automatic FYI emails for Meeting Action Items

Tags:
| |

Now you can get the Action Items (AIs) delivered right to your inbox! Joanna Smith’s (@dontmesswithjo) custom solution to integrate Google Docs with Apps Script allows you to send everyone a personalized list of their AIs at the end of every meeting.

Source: Send automatic FYI emails for Meeting Action Items

Solutions, Sheets

How to use Google Spreadsheet as Admin Interface for your Firebase project

Tags:
| | 0 Comments |

Manage, verify and approve transactions in your application using cloud functions and Google Apps Script.

Nice little tutorial showing two communication between Google Sheets and Firebase using Google Apps Script.

Source: How to use Google Spreadsheet as Admin Interface for your Firebase project

Solutions, Sheets

I created a Twitter Bot from nothing but a Google Sheet – And I Didn’t Even Know The Scripting Language…

Tags:
| | 0 Comments |

… that job taught me two very important lessons: repetitive stuff needs to be automated; the best way to learn to code is with a tangible, objective problem that needs a solution. … It was then I decided to go all-out and make a Twitter Bot. Having no relevant experience or clue of what I was doing, my goal was simple: send a few tweets with relevant quotes, readings, and information for Orthodox Christians

Very detailed post from Peter Berthelsen on his journey from no-code to making a functional Twitter bot and if you keep reading to the end you’ll get a link to Peter’s follow-up post with a template and setup instructions. These posts are great examples of the empowerment Google Apps Script can give to people.

Source: I created a Twitter Bot from nothing but a Google Sheet