The Google Forms API provides programmatic access for managing Google Forms and acting on responses— empowering developers to build powerful integrations on top of Forms.
Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers and users with personal Google Accounts
We’ve shared a couple of updates on the new Google Forms API previously here on Apps Script Pulse. The good news is the Forms API is now out of beta and available for testing and deployment. For Google Apps Script devs I’m sure you are thinking ‘but we can use the Forms Service?’ You can and likely in most instances to be the first port of call, but the new API brings some additional functionality not supported in Forms Service, in particular, a trigger when a Google Form is edited.
Google Cloud Innovator’s inaugural event, Innovators Hive is a virtual, global, and free event limited to 1,000 developers and practitioners. Organized for and with the Cloud community, it focuses on deep technical content presented by Champion Innovator and Google thought leaders and luminaries.
Google Cloud Innovators is a new program created by Google for anyone using Google Cloud to come together as a community to learn, share and collaborate:
You know Google Cloud. Now it’s time for Google Cloud to get to know you.
Join the program by claiming the Innovators Program badge on your developer profile. From the beginning, you will receive invitations to hear from Google Cloud executives and Developer Advocates, roadmap presentations, and a chance for an invitation to join our new series of Innovator community events.
We’re just getting started. We are working on customizing experiences across Google Cloud to incorporate your identity as an Innovator, and make your time with Cloud a more personal and collaborative journey.
As part of the Google Cloud Innovator program Google is hosting ‘Innovators Hive’, 29-30 March 2022. This is a free event where you can hear from Google and community contributors about the latest developments in Google Cloud. There isn’t a published programme yet but you can get a sense of what will be talked about from the featured speakers page.
A number of Google Workspace experts will be contributing sessions to Innovator Hive, many of whom we’ve featured regularly here in Apps Script Pulse, including:
Charles Maxson
Christian Schalk
Clay Smith
Adam Morris
Alice KeelerÂ
Jasper Duizendstra
Scott Donald
Sourabh Choraria
There will be a couple of community meetups for folks who build solutions on Google Workspace or for folks who are curious about what the possibilities are. One of these will be a Totally Unscripted reunion where I’ll be joining Charles Maxson which will be an opportunity to ask a question or share your ideas about Workspace Development. Â
To join this event if not already a Google Cloud Innovator check out the Google Cloud Innovators program page to become a member, then register for Innovators Hive 2022. Both Google Cloud Innovator and Innovator Hive are FREE!
As a little experiment for Apps Script Pulse fans we are going to start reposting the official Google Apps Script release notes on this site. Why? The release notes can be incredibly useful to keep up-to-date with latest Google Apps Script developments but currently unless you keep checking the page (or know someone with an unofficial RSS feed), they can be hard to monitor.
The February 14, 2022 release note contains a very useful security update which will let yo know when someone outside your organisation updates a script project. Details and link below:
February 14, 2022
Owners receive email alerts when someone outside the owner’s organization edits a script project in the new integrated development environment (IDE).
For container-bound scripts: If someone outside the container owner’s organization creates or edits a container-bound script project, the container owner receives an email notification.
For standalone scripts: If someone outside the script project owner’s organization edits a standalone script project, the script project owner receives an email notification.
You can improve the performance of Google Sheets and speed up calculations.
Via Sourabh Choraria (@schoraria911) we picked up this tweet from
Michael Avrukin who is working on the Google Sheets help center documentation:
Hi there dedicated #sheets users, we are starting to work on our help center content – here is our first article in the new format. I’ll appreciate thoughts / feedback anyone has. #googlesheetshttps://t.co/1wJ5abJZiI@benlcollins
The page includes a number of useful tips to speed up Google Sheet calculations and whilst not specifically Google Apps Script related provides useful information on some things you can look out for when your Google Sheet starts getting slow.
2021 was also a year for Platform milestones, Google Workspace grew to more than 3 billion users globally, we reached more than 5,300 public apps in the Google Workspace Marketplace, and we crossed over 4.8 billion apps installed (up from 1 billion in 2020)! We were also busy bringing Platform innovations and improving our developer experience to help building for Google Workspace easier and faster. Here’s a look at some of the key enhancements the Google Workspace Platform brought to the developer community.
There were a number of announcements for Google Workspace developers in 2021 and in this post Charles Maxson provides a summary of the key points.
Continuing with updates to further improve the developer experience, we are excited to announce Google Workspace Marketplace badges. The new badges will allow developers to promote their published Google Workspace Marketplace applications on their own websites. Users will be taken directly to the Marketplace application listing, where they can review application details, privacy policy, terms of service, and more. These users will then be able to securely install applications directly from the Google Workspace Marketplace.
The post from Google contains more information about the benefits of using a promotional badge and how to get on for your Google Workspace Marketplace add-ons.
The Google Forms API is now rolling out as an Open Beta which means developers who are part of our Early Adopter Program can make their integrations available to the public. We’ll no longer require individual end-user accounts to be allowlisted. … Developers can apply to join our Early Adopter Program and begin developing using the Google Forms API by filling out this form.
In other Google Workspace news the new Google Forms API continues it’s journey to general availability with the announcement of the open beta. Just as the other Google Workspace REST APIs can be useful to Google Apps Script developers it’s useful to keep an eye on what is possible in the Forms API.
We’re updating the menus in Google Sheets to make it easier to locate the most commonly-used features. Some of your favorite menu items may have moved a little, but all existing functionality is still available. We hope that their new home will be more intuitive and make it easier and faster to navigate the product.
Google Workspace Updates
Google have updated the menus in Google Sheets to help with discoverability. For Google Workspace Developers one of the big changes is the new Extensions menu which replaces ‘Add-ons’ and includes links to Macros, Script Editor and AppSheet. Whilst painful if you need to update support documentation the new structure will hopefully make the location of these tools more intuitive. We covered the Google Sheets menu update in the latest episode of Totally Unscripted:
Google Workspace Marketplace is proud to announce the availability for developers to display pricing for their applications published in the Google Workspace Marketplace, and the date their application listing was last updated.
Monetization of Google Workspace Marketplace Add-ons is a topic that has often been raised. This latest update from Google doesn’t directly address in-app purchasing but it does provide a way for listings to be more transparent about pricing. Check the source post for more details on this and other Google Workspace Marketplace updates.
Google is proud to announce the Google Forms API! The Forms API is currently available in Restricted Beta, with Open Beta expected to follow in Q4. … The new Google Forms API provides programmatic access for managing forms and acting on responses, empowering developers to build powerful integrations on top of Forms.
The Forms API is currently in Restricted Beta. We encourage you to apply here to be an early adopter to get started with the API today! We’ll also send you important updates about Open Beta and improvements to the API. To keep up to date with all the APIs of your favorite Google Apps, please subscribe to the Google Workspace Developer Newsletter.
On Totally Unscripted we were delighted to have Christian Schalk (Developer Advocate, Google) and Hannah Pho (Software Engineer, Google) as well as early Forms API partners Charles Kemp (Strategic Alliances Manager, Zapier) and Charles Wiles (CEO, Zzish), talk about the new Forms API. A recording of the show is on YouTube and show notes will soon be added to the Totally Unscripted website.
