Tag Archives: developers

30 years of family videos in an AI archive

My dad got his first video camera the day I was born nearly three decades ago. “Say hello to the camera!” are the first words he caught on tape, as he pointed it at a red, puffy baby (me) in a hospital bassinet. The clips got more embarrassing from there, as he continued to film through many diaper changes, temper tantrums and—worst of all—puberty.

Most of those potential blackmail tokens sat trapped on miniDV tapes or scattered across SD cards until two years ago when my dad uploaded them all to Google Drive. Theoretically, since they were now stored in the cloud, my family and I could watch them whenever we wanted. But with more than 456 hours of footage, watching it all would have been a herculean effort. You can only watch old family friends open Christmas gifts so many times. So, as an Applied AI Engineer, I got down to business and built an AI-powered searchable archive of our family videos.

If you’ve ever used Google Photos, you’ve seen the power of using AI to search and organize images and videos. The app uses machine learning to identify people and pets, as well as objects and text in images. So, if I search “pool” in the Google Photos app, it’ll show me all the pictures and videos I ever took of pools.

But for this project, I needed a couple of features Photos doesn’t (yet!) support. First, because my dad’s first camera recorded footage to miniDV tapes, those videos were uploaded as meaty, two-hour-long movies with no useful metadata. Instead, my dad would start a clip by saying, “let me put a date on the screen here...” and a little white text snippet would appear in the bottom right corner of the frame. In between shots on a single reel, he’d say: “Say goodbye, I’m going to fade out now.” I would scream, “NO, DON’T FADE OUT,” while the screen faded to black. So, my first step was to use machine learning to automatically parse the date shown on the screen, and split the single long video into shorter clips after each fade out.

video screenshot

In this picture, you can see the timestamp shown on screen. Using the Vision API, I could extract it to sort my videos by date.

For this, I turned the Video intelligence API, a Google Cloud tool that lets developers analyze videos with machine learning. It allows you to replicate many of the features found in the Google Photos app—like tagging objects in images and recognizing on-screen text—and a whole lot more. For example, the API’s shot change detection feature automatically finds the timestamps in videos where a scene changes, this allowed me to split those longs videos into smaller chunks. 

Using the label detection feature, I could search for all sorts of different events, like “bridal shower,” “wedding,” “bat and ball games” and “baby.” By searching “performance,” I was able to finally find one of my life’s proudest accomplishments on tape—a starring role singing “It’s Not Easy Being Green” in my kindergarten’s production of the Sesame Street musical.

home video 2

My starring role as Kermit the Frog in my school’s Sesame Street musical. The Video Intelligence API tagged it as “performance”.  

The Video Intelligence API’s real “killer feature” for me was its ability to do audio transcription. By transcribing my videos, I was able to query clips by what people said in them. I could search for specific names (“Scott,” “Dale,” “grandma”), proper nouns (“Chuck E Cheese”, “Pokemon”), and for unique phrases. By searching “first steps,” I found a clip of my dad saying, “Here she comes… plunk. That’s the first time she’s taken major steps” alongside a video of my managing, just barely, to waddle along.

homevideo3

My first steps that I was able to find with the Video Intelligence API’s Transcription feature. Here, my dad says, “...this is the first time she’s taken major steps.”

In the end, machine learning helped me build exactly the kind of archive I wanted—one that let me search my family videos by memories, not timestamps.

P.S. Want to see how I built it? Check out my technical blog post or catch the video on the Cloud Youtube Channel

Finding community and a career in a new country

When Henna Singh decided to move her family from India to Ireland so her husband could pursue his master’s degree, she was determined to meet the moment head on. Not only did she dive into learning a new country and culture, but also she decided to take on a whole new career. “It was a time where I had no regulations,” she says. “I could do whatever I wanted.” 

To her, the timing couldn’t have been better. She needed to find work in her new city of Dublin and saw that programming, with all its job openings, would be the perfect way to engage her passion for building and creating new things. There was only one catch: She first needed to learn how to code. 

Seeking both personal and professional development in Dublin, Henna started searching for opportunities that allowed her to learn code with others in a classroom setting. That instinct helped her find a program to study Android offered by Udacity and Grow with Google. Henna applied, and heard back after a few weeks. She got a full scholarship.

As she started to attend more classes and meet more people, she noticed that many of her new friends belonged to different Google Developer Groups (GDG). These groups are independently run communities, guided by Google, that bring local developers with similar interests in technology together. So in the same spirit that led her to move from India to Ireland, a curious Henna immediately called the organizer of GDG Dublin, the Google Developer Group that was closest to her. After hearing Henna’s story on learning Android from scratch, the organizer invited Henna to give a talk about her journey to the group.

Henna started her presentation to an excited crowd, but was struck by an overwhelming sense of stage fright. So the GDG Dublin community quickly sprung to action. Filled with Google mentors, experts and local thought leaders, the group offered Henna advice from their own experience as public speakers. “They told me to slow down and take a breath. They told me I could do it,” Henna says. “I felt like I had such huge support. That moment helped me find my confidence moving forward.” She pushed ahead, and nailed her presentation. She knew she found her developer family, and later helped the group organize events. 

Empowered by the expertise and warm family support she received during her first talk, Henna realized that public speaking, even when it goes all wrong, is not that scary. She soon signed up to give a global talk at DevFest Dublin 2018, and then went on to seek out more leadership roles in her own local developer community. 

All of these experiences, paired with the Google mentorship and technical education content she received, helped Henna eventually land a full-time role as a Technical Services Engineer. In her free time, she is also a Community Organizer for Google’s Women Techmakers, where she helps connect local companies to women in development. And, of course, she is still a dedicated member of her GDG Dublin family.

Want to join a Google Developer Group near you?  Learn more about how to get involved virtually or in person, on our website.

Finding community and a career in a new country

When Henna Singh decided to move her family from India to Ireland so her husband could pursue his master’s degree, she was determined to meet the moment head on. Not only did she dive into learning a new country and culture, but also she decided to take on a whole new career. “It was a time where I had no regulations,” she says. “I could do whatever I wanted.” 

To her, the timing couldn’t have been better. She needed to find work in her new city of Dublin and saw that programming, with all its job openings, would be the perfect way to engage her passion for building and creating new things. There was only one catch: She first needed to learn how to code. 

Seeking both personal and professional development in Dublin, Henna started searching for opportunities that allowed her to learn code with others in a classroom setting. That instinct helped her find a program to study Android offered by Udacity and Grow with Google. Henna applied, and heard back after a few weeks. She got a full scholarship.

As she started to attend more classes and meet more people, she noticed that many of her new friends belonged to different Google Developer Groups (GDG). These groups are independently run communities, guided by Google, that bring local developers with similar interests in technology together. So in the same spirit that led her to move from India to Ireland, a curious Henna immediately called the organizer of GDG Dublin, the Google Developer Group that was closest to her. After hearing Henna’s story on learning Android from scratch, the organizer invited Henna to give a talk about her journey to the group.

Henna started her presentation to an excited crowd, but was struck by an overwhelming sense of stage fright. So the GDG Dublin community quickly sprung to action. Filled with Google mentors, experts and local thought leaders, the group offered Henna advice from their own experience as public speakers. “They told me to slow down and take a breath. They told me I could do it,” Henna says. “I felt like I had such huge support. That moment helped me find my confidence moving forward.” She pushed ahead, and nailed her presentation. She knew she found her developer family, and later helped the group organize events. 

Empowered by the expertise and warm family support she received during her first talk, Henna realized that public speaking, even when it goes all wrong, is not that scary. She soon signed up to give a global talk at DevFest Dublin 2018, and then went on to seek out more leadership roles in her own local developer community. 

All of these experiences, paired with the Google mentorship and technical education content she received, helped Henna eventually land a full-time role as a Technical Services Engineer. In her free time, she is also a Community Organizer for Google’s Women Techmakers, where she helps connect local companies to women in development. And, of course, she is still a dedicated member of her GDG Dublin family.

Want to join a Google Developer Group near you?  Learn more about how to get involved virtually or in person, on our website.

Finding community and a career in a new country

When Henna Singh decided to move her family from India to Ireland so her husband could pursue his master’s degree, she was determined to meet the moment head on. Not only did she dive into learning a new country and culture, but also she decided to take on a whole new career. “It was a time where I had no regulations,” she says. “I could do whatever I wanted.” 

To her, the timing couldn’t have been better. She needed to find work in her new city of Dublin and saw that programming, with all its job openings, would be the perfect way to engage her passion for building and creating new things. There was only one catch: She first needed to learn how to code. 

Seeking both personal and professional development in Dublin, Henna started searching for opportunities that allowed her to learn code with others in a classroom setting. That instinct helped her find a program to study Android offered by Udacity and Grow with Google. Henna applied, and heard back after a few weeks. She got a full scholarship.

As she started to attend more classes and meet more people, she noticed that many of her new friends belonged to different Google Developer Groups (GDG). These groups are independently run communities, guided by Google, that bring local developers with similar interests in technology together. So in the same spirit that led her to move from India to Ireland, a curious Henna immediately called the organizer of GDG Dublin, the Google Developer Group that was closest to her. After hearing Henna’s story on learning Android from scratch, the organizer invited Henna to give a talk about her journey to the group.

Henna started her presentation to an excited crowd, but was struck by an overwhelming sense of stage fright. So the GDG Dublin community quickly sprung to action. Filled with Google mentors, experts and local thought leaders, the group offered Henna advice from their own experience as public speakers. “They told me to slow down and take a breath. They told me I could do it,” Henna says. “I felt like I had such huge support. That moment helped me find my confidence moving forward.” She pushed ahead, and nailed her presentation. She knew she found her developer family, and later helped the group organize events. 

Empowered by the expertise and warm family support she received during her first talk, Henna realized that public speaking, even when it goes all wrong, is not that scary. She soon signed up to give a global talk at DevFest Dublin 2018, and then went on to seek out more leadership roles in her own local developer community. 

All of these experiences, paired with the Google mentorship and technical education content she received, helped Henna eventually land a full-time role as a Technical Services Engineer. In her free time, she is also a Community Organizer for Google’s Women Techmakers, where she helps connect local companies to women in development. And, of course, she is still a dedicated member of her GDG Dublin family.

Want to join a Google Developer Group near you?  Learn more about how to get involved virtually or in person, on our website.

Finding community and a career in a new country

When Henna Singh decided to move her family from India to Ireland so her husband could pursue his master’s degree, she was determined to meet the moment head on. Not only did she dive into learning a new country and culture, but also she decided to take on a whole new career. “It was a time where I had no regulations,” she says. “I could do whatever I wanted.” 

To her, the timing couldn’t have been better. She needed to find work in her new city of Dublin and saw that programming, with all its job openings, would be the perfect way to engage her passion for building and creating new things. There was only one catch: She first needed to learn how to code. 

Seeking both personal and professional development in Dublin, Henna started searching for opportunities that allowed her to learn code with others in a classroom setting. That instinct helped her find a program to study Android offered by Udacity and Grow with Google. Henna applied, and heard back after a few weeks. She got a full scholarship.

As she started to attend more classes and meet more people, she noticed that many of her new friends belonged to different Google Developer Groups (GDG). These groups are independently run communities, guided by Google, that bring local developers with similar interests in technology together. So in the same spirit that led her to move from India to Ireland, a curious Henna immediately called the organizer of GDG Dublin, the Google Developer Group that was closest to her. After hearing Henna’s story on learning Android from scratch, the organizer invited Henna to give a talk about her journey to the group.

Henna started her presentation to an excited crowd, but was struck by an overwhelming sense of stage fright. So the GDG Dublin community quickly sprung to action. Filled with Google mentors, experts and local thought leaders, the group offered Henna advice from their own experience as public speakers. “They told me to slow down and take a breath. They told me I could do it,” Henna says. “I felt like I had such huge support. That moment helped me find my confidence moving forward.” She pushed ahead, and nailed her presentation. She knew she found her developer family, and later helped the group organize events. 

Empowered by the expertise and warm family support she received during her first talk, Henna realized that public speaking, even when it goes all wrong, is not that scary. She soon signed up to give a global talk at DevFest Dublin 2018, and then went on to seek out more leadership roles in her own local developer community. 

All of these experiences, paired with the Google mentorship and technical education content she received, helped Henna eventually land a full-time role as a Technical Services Engineer. In her free time, she is also a Community Organizer for Google’s Women Techmakers, where she helps connect local companies to women in development. And, of course, she is still a dedicated member of her GDG Dublin family.

Want to join a Google Developer Group near you?  Learn more about how to get involved virtually or in person, on our website.

Expanding our support for Black founders

As our CEO Sundar Pichai announced today, Google will invest $175 million toward economic opportunity for Black business owners, startup founders, job seekers and developers. A part of this initiative is the inaugural Google for Startups Accelerator in the U.S: a virtual three-month program for Black founders from across the country. 

During the accelerator, startups will be paired with Google experts to identify and solve their most pressing technical challenges, everything from implementing machine learning to developing mobile apps to improving user experience design. Founders will also participate in workshops focused on fundraising, hiring and sales. Interested startups can apply through June 30th and the accelerator will kick off in August. This will be the first in a series of Google for Startups Accelerators focused on underrepresented founders.

Along with the accelerator, we're creating a $5 million Google for Startups Black Founders Fund. This fund will provide cash awards up to $100,000 to selected startups from our U.S. programs and partner communities. These cash awards will go to startups with Black founders, who have been deeply impacted by COVID-19 and who are disproportionately locked out of access to capital.

These efforts are a part of our longstanding and growing commitment to support the Black startup community through partnerships with organizations like Founder Gym, Backstage Capital, and American Underground which are working to close the funding gap and empower Black entrepreneurs. This year, we’ve focused our efforts in Atlanta, forging new partnerships with the Russell Center for Innovation and Entrepreneurship and Collab Studio, and creating the Google for Startups Founders Academy.

Though we see this as a step forward, we know there is much more work to be done to level the playing field for founders. If you or someone you know would be a great fit for the Google for Startups Accelerator, encourage them to apply by June 30th.

Everything announced at the Google for Games Developer Summit

Every year, GDC is a moment to celebrate our successes and learn from one another. Although we won’t be gathering in person this year, we’re bringing you the latest updates at our Google for Games Developer Summit, where developers can watch the announcements and virtually attend sessions for free  at g.co/gamedevsummit.

We also realize this may have been a big sacrifice for your teams. For some, GDC is a major opportunity for annual business development and marketing strategies. That’s why we’ve partnered with WINGS andthe GDC Relief Fund to support teams in continuing to do what they do best: build world-class games.

Now more than ever, games are helping players around the globe feel more connected. To ensure you have access to the tools you need to deliver the best possible game experiences, our teams have been building solutions to help you tackle your biggest challenges and set you up for long-term success. You can check out the highlights below:

Build games and reach a wider audience with Android and Google Play

We’re making it easier for you to build and optimize games on Android. Learn about new tools to help your development process, provide greater insights into your game’s performance, and access a wider player base. Once you’re ready to publish, review our updated guidance to ensure your game is high-quality and leverages various features and services for a successful go-to-market with Google Play.

Grow your business with Google Ads and AdMob

The best game developers think about their players first—both when creating experiences people love and building sustainable businesses. Google Ads and AdMob are introducing new ways to analyze and utilize player insights to help you grow your games and earn the revenue you need to improve them over time.

Simply scale your global game with Google Cloud Game Servers 

Hosting and scaling a global game can be challenging and requires that you either build costly solutions, or turn to pre-packaged ones that limit choice and control. To offer you more choices and time to dedicate to core elements of producing games, the Google Cloud team is introducing a simplified, convenient way for managing game server clusters.

Build and publish the next generation of games with Stadia

New game platforms present new challenges and opportunities for game creators and Google is here to help. For developers of all sizes looking to bring their games to Stadia, the team is unveiling Stadia Makers, a new program to support the independent development community.

We’re excited to see this community continue to delight players around the world, and we look forward to building what’s next, together. From all of us, thank you for keeping this community thriving.

Source: Android


Everything announced at the Google for Games Developer Summit

Every year, GDC is a moment to celebrate our successes and learn from one another. Although we won’t be gathering in person this year, we’re bringing you the latest updates at our Google for Games Developer Summit, where developers can watch the announcements and virtually attend sessions for free  at g.co/gamedevsummit.

We also realize this may have been a big sacrifice for your teams. For some, GDC is a major opportunity for annual business development and marketing strategies. That’s why we’ve partnered with WINGS andthe GDC Relief Fund to support teams in continuing to do what they do best: build world-class games.

Now more than ever, games are helping players around the globe feel more connected. To ensure you have access to the tools you need to deliver the best possible game experiences, our teams have been building solutions to help you tackle your biggest challenges and set you up for long-term success. You can check out the highlights below:

Build games and reach a wider audience with Android and Google Play

We’re making it easier for you to build and optimize games on Android. Learn about new tools to help your development process, provide greater insights into your game’s performance, and access a wider player base. Once you’re ready to publish, review our updated guidance to ensure your game is high-quality and leverages various features and services for a successful go-to-market with Google Play.

Grow your business with Google Ads and AdMob

The best game developers think about their players first—both when creating experiences people love and building sustainable businesses. Google Ads and AdMob are introducing new ways to analyze and utilize player insights to help you grow your games and earn the revenue you need to improve them over time.

Simply scale your global game with Google Cloud Game Servers 

Hosting and scaling a global game can be challenging and requires that you either build costly solutions, or turn to pre-packaged ones that limit choice and control. To offer you more choices and time to dedicate to core elements of producing games, the Google Cloud team is introducing a simplified, convenient way for managing game server clusters.

Build and publish the next generation of games with Stadia

New game platforms present new challenges and opportunities for game creators and Google is here to help. For developers of all sizes looking to bring their games to Stadia, the team is unveiling Stadia Makers, a new program to support the independent development community.

We’re excited to see this community continue to delight players around the world, and we look forward to building what’s next, together. From all of us, thank you for keeping this community thriving.

Source: Android


Highlights from the first year of .dev

A year ago, our Google Registry team launched .dev—a top-level domain (TLD) for developers, designers, technical writers, and technology enthusiasts. This new TLD gave people the chance to register memorable domain names that can be hard to find on older domains, with a descriptive ending that’s especially relevant to them.

The .dev TLD is on the HSTS preload list, which means it’s secure for both website owners and their visitors. Placement on the HSTS preload list ensures HTTPS encryption for your entire website, which helps protect visitors against ad malware, tracking injection from ISPs, and potential spying when using open Wi-Fi networks. With so much built-in security, .dev has become the natural place for technology makers to share resources, showcase great work, and foster community.

In the last year, over 150,000 .dev domains have been registered, and we’ve seen many creative uses of the TLD. Here are just a few of the exciting examples we’ve seen.

.dev 1 year anniversary

A video with three .dev tips

Atlassian

Atlassian launched both software.dev and cicd.dev to share insights into today’s software development landscape and how software and IT professionals use CI/CD tools. Using .dev domains helped them market both sites, which have sparked conversations on social media among the developer community.

Cloudflare

Cloudflare launched workers.dev to help developers build serverless websites and applications that deploy directly onto subdomains of workers.dev. The TLD made it possible for Cloudflare to use a domain name that’s both descriptive and easy to remember. And over the last year, they’ve seen developers create handy apps like this “lazy invoice” tool.

Salesforce

Salesforce used lwc.dev to launch a site dedicated to Lightning Web Components (their open source project) where professional developers can find online documentation, copy source code for various recipes, and engage with the Lightning Web Components community.

Google Developer Relations

The Google Developer Relations team launched google.dev for developers to explore and learn about all the technologies Google has to offer. You can sign up for the waitlist for the beta version of google.dev, which lets developers create profiles and earn badges by passing technical challenges. The team sends out new invites regularly, so be sure to sign up.

Go Programming Language

Our Go Language team launched go.dev on the 10th anniversary of the open source programming language to provide Go developers a hub where they can find learning resources, including featured use cases and customer stories of other companies using Go.

Build your own .dev experience

From the start, we envisioned .dev as a home for developers and technology makers, and it’s been wonderful to see all the amazing work showcased in this domain. To celebrate .dev’s first birthday, we created a short video of some of our favorite .dev users sharing their tips for building great websites. We hope you’ll find it useful as you begin your next project, and we hope it inspires you to create your own .dev experience. Visit get.dev to learn more and get started.

Evolving automations into applications using Apps Script

Posted by Wesley Chun (@wescpy), Developer Advocate, Google Cloud

Editor’s Note: Guest authors Diego Moreno and Sophia Deng (@sophdeng) are from Gigster, a firm that builds dynamic teams made of top global talent who create industry-changing custom software.

Prelude: Data input & management … three general choices

Google Cloud provides multiple services for gathering and managing data. Google Forms paired with Google Sheets are quite popular as they require no engineering resources while being incredibly powerful, providing storage of up to 5 million rows of data and built-in analytics for small team projects.

At the other end of the spectrum, to support a high volume of users or data, Google Cloud provides advanced serverless platforms like Google App Engine (web app-hosting) and Google Cloud Functions (function/service-hosting) that can use Google Cloud Firestore for fast and scalable data storage. These are perfect for professional engineering teams that need autoscaling to respond to any level of user traffic and data input. Such apps can also be packaged into a container and deployed serverlessly on Google Cloud Run.

However, it's quite possible your needs are right in-between. Today, we're happy to present the Gigster story and their innovative use of Google Apps Script—a highly-accessible service conventionally relegated to simple macro and add-on development, but which Gigster used to its advantage, building robust systems to transform their internal operations. Apps Script is also serverless, meaning Gigster didn't have to manage any servers for their application nor did they need to find a place to host its source code.

The Gigster story

Gigster enables distributed teams of software engineers, product managers and designers to build software applications for enterprise clients. Over the past five years, Gigster has delivered thousands of projects, all with distributed software teams. Our group, the Gigster Staffing Operations Team, is responsible for assembling these teams from Gigster’s network of over 1,000 freelancers.

Two years ago, our team began building custom software to automate the multi-stage and highly manual team staffing process. Building internal software has allowed the same-size Staffing Operations Team (3 members!) to enjoy a 60x reduction in time spent staffing each role.

The Apps Script ecosystem has emerged as the most critical component in our toolkit for building this internal software, due to its versatility and ease of deployment. We want to share how one piece of the staffing process has evolved to become more powerful over time thanks to Apps Script. Ultimately, we hope that sharing this journey enables all types of teams to build their own tools and unlock new possibilities.

End-to-end automation in Google Sheets

Staffing is an operationally intensive procedure. Just finding willing and able candidates requires numerous steps:

  1. Gathering and formatting customer requirements.
  2. Communicating with candidates through multiple channels.
  3. Logging candidate responses.
  4. Processing paperwork for placement

To add complexity, many of these steps require working with different third-party applications. For awhile, we performed every step manually, tracking every piece of data generated in one central Sheet (the “Staffing Broadcast Google Sheet”). At a certain point, this back-and-forth work to log data from numerous applications became unsustainable. Although we leveraged Google Sheets features like Data Validation rules and filters, the Staffing Broadcast Sheet could not alleviate the high degree of manual processes that were required of the team.

centralized Staffing Broadcast Google Sheet

The centralized Staffing Broadcast Google Sheet provided organization, but required a high degree of manual entry for tracking candidate decisions.

The key transformation was integrating Sheets data with third-party APIs via Apps Script. This enabled us to cut out the most time-consuming operations. We no longer had to flip between applications to message candidates, wait for their replies, and then manually track responses.

To interact with these APIs, we built a user interface directly into the Staffing Broadcast Google Sheet. By introducing an information module, as well as drop-down lists and buttons, we were able to define a small set of manual actions versus the much wider list of tasks the tool would perform automatically across multiple applications.

integrating Apps Script with third-party APIs

By integrating Google Apps Script with third-party APIs and creating a user interface, we evolved the Staffing Broadcast Tool to centralize and automate almost every step of the staffing process.

doPost() is the key function in our staffing tool that facilitates third-party services triggering our Apps Script automations. Below is a snippet of how we listened to candidates' responses from a third-party messaging application. In this case, queueing the third-party message in a Google Sheet so it can be processed with improved error-handling.

/**
* Receive POST requests and record to queue.
*/
doPost(e) {
var payload = e.postData.contents;
SpreadsheetApp.openById(SPREADSHEET_ID)
.getSheetByName("Unprocessed")
.appendRow([payload]);
return ContentService.createTextOutput(""); // Return 200
}

Almost all manual work associated with finding candidates was automated through the combination of integrations with third-party APIs and having a user interface to perform a small, defined set of actions. Our team’s day-to-day became shockingly simple: select candidates to receive messages within the Staffing Broadcast Tool, then click the “Send Broadcast” button. That’s it. The tool handled everything else.

Leveraging Sheets as our foundation, we fundamentally transformed our spreadsheet into a custom software application. The spreadsheet went from a partially automated datastore to a tool that provided an end-to-end automated solution, requiring only the click of a few buttons to execute.

Evolution into a standalone application

While satisfied, we understood that having our application live in Google Sheets had its limitations, namely, it was difficult for multiple team members to simultaneously use the tool. Using doGet(), the sibling to doPost(), we began building an HTML frontend to the Staffing Broadcast Tool. In addition to resolving difficulties related to multiple users being in a spreadsheet, it also allowed us to build an easier-to-use and more responsive tool by leveraging Bootstrap & jQuery.

Having multiple users in a single Google Sheet can create conflicts, but Apps Script allowed us to build a responsive web app leveraging common libraries like Bootstrap & jQuery that eliminated those problems while providing an improved user experience.

When other teams at Gigster got wind of what we built, it was easy to grant access to others beyond the Staffing Operations Team. Since Apps Script is part of the G Suite developer ecosystem, we relied on Google’s security policies to help deploy our tools to larger audiences.

While this can be done through Google’s conventional sharing tools, it can also be done with built-in Apps Script functions like Session.getActiveUser() that allow us to restrict access to specific Google users. In our case, those within our organization plus a few select users.

To this day, we continue to use this third version of the Staffing Broadcast Tool in our daily operations as it supports 100% of all client projects at Gigster.

Conclusion

By fundamentally transforming the Staffing Broadcast Tool with Apps Script, Gigster’s Staffing Operations Team increased its efficiency while supporting the growth of our company. Inspired by these business benefits, we applied this application-building approach using Apps Script for multiple tools, including candidate searching, new user onboarding, and countless automations.

Our team’s psychological shift about how we view what we are capable of, especially as a non-engineering team, has been the most valuable part of this journey. By leveraging an already familiar ecosystem to build our own software, we have freed team members to become more self-sufficient and valuable to our customers.

To get started on your Apps Script journey, we recommend you check out the Apps Script Fundamentals playlist and the official documentation. And if you're a freelancer looking to build software applications for clients, we’re always looking for talented software engineers, product managers or designers to join Gigster’s Talent Network.

Thank you to Sandrine Bitton, the third member of the Staffing Operations Team, for all her help in the development of the Staffing Broadcast Tool.