AppsScriptPulse

The Transformative Power of Generative AI: Reimagining the Enterprise with Gemini for Google Workspace

This article was co-authored with Gemini for Google Workspace. You can read the full transcript of our conversation.

I appreciate this isn’t the typical Pulse post, but in my mind a lot of Google Workspace Developers who subscribe to this site have a wider interest in Google Workspace. Having worked with and supported a number of customers exploring Gemini for Google Workspace I thought it would be useful to sharing some of my thoughts and observations regarding the transformative power of Generative AI. As part of this I share insights around:

  • The importance of change management in adopting GenAI.
  • Mastering the art of prompting and interaction.
  • The need for continuous learning in a rapidly evolving landscape.
  • The future of human-AI collaboration.

Introduction

Imagine collaborating with an AI to draft a compelling marketing campaign, brainstorming ideas in a fluid conversation, and watching as it generates compelling copy and visuals in real-time. This is the power of generative AI tools like Gemini for Google Workspace, and it’s transforming how enterprises work.

My own journey with generative AI began in late 2023 when I had the opportunity to be part of Google Cloud’s trusted tester program. Working with early models in MakerSuite, Bard, and Duet AI gave me a glimpse of this transformative power. I was immediately struck by the shift to a conversational paradigm. We’re no longer just issuing commands to machines; we’re engaging in dynamic dialogues to create and innovate.

Having now supported several businesses with Gemini for Workspace ‘proof of value’ pilots, I’ve come to realize that simply introducing these powerful tools isn’t enough. To truly unlock the potential of generative AI like Gemini, organizations need a multifaceted approach. This includes investing in training, fostering internal “champions,” strategically identifying pain points for improvement, measuring success, and thoughtfully disseminating new ways of working. This is the key to successfully integrating this revolutionary technology into the enterprise.

The Promise of GenAI for Enterprise Productivity

McKinsey’s research paints a compelling picture of generative AI’s potential to revolutionize productivity. They estimate that generative AI could add the equivalent of $2.6 trillion to $4.4 trillion annually across the 63 use cases they analysed. This staggering figure underscores the transformative impact this technology could have on businesses across various sectors, from automating mundane tasks to unlocking entirely new levels of creativity and efficiency.

But the true promise of GenAI extends far beyond simply saving time. Tools like Gemini empower employees to:

  • Improve quality: By providing intelligent suggestions, generating alternative approaches, and catching errors, GenAI helps elevate the overall quality of work.
  • Upskill and learn: Gemini not only provides answers but often explains the “why” and “how” behind them, offering valuable learning opportunities and fostering deeper understanding.
  • Conduct advanced analysis: With the ability to analyse vast amounts of data, GenAI unlocks new levels of insight and understanding that were previously impossible.

Just this week, I was working with a pilot participant from a company’s People team. They needed to analyse an employee satisfaction survey with hundreds of free-text responses. Imagine the task: categorizing those responses by theme, extracting key quotes, and generating a comprehensive report with recommendations. Gemini was able to analyse all the responses and create a draft report in minutes – a task that would normally take a full day. While the person still needed to check the data and refine the report, having this head start, complete with accurate thematic categorization and relevant quotes, significantly enhanced their efficiency and allowed them to focus on higher-level analysis and recommendations.

These benefits highlight the transformative potential of GenAI to not just speed up work, but to fundamentally enhance the way we work and the value we create.

The Importance of Change Management

Introducing a powerful tool like Gemini into an organization is more than just adding a new piece of software; it requires a fundamental shift in how people work and think about their roles. This is where change management becomes crucial. The ADKAR model, which focuses on Awareness, Desire, Knowledge, Ability, and Reinforcement, provides a useful framework for navigating this transition.

  • Awareness: First, employees need to be aware of what Gemini is, its capabilities, and how it can impact their work. This goes beyond simply showcasing features; it’s about communicating the ‘why’ behind the change and painting a clear picture of how Gemini can benefit them individually and the organization as a whole.
  • Desire: Next, we need to foster a desire to use Gemini. This involves addressing concerns, highlighting the advantages, and creating a sense of excitement about the possibilities. One of the biggest hurdles is overcoming the mindset of ‘I need to do this myself.’ Many employees have never had the experience of having an assistant, so it’s about encouraging them to embrace Gemini as a valuable partner that can augment their capabilities and free them to focus on higher-value tasks. In one of my pilot programs, an employee was hesitant to use Gemini in Gmail because it felt like ‘cheating’ to spend less time writing emails. To address this, I explained that Gemini wasn’t about cutting corners; it was about freeing up time for more valuable activities. By using Gemini to generate a first draft, the employee could then dedicate more time to refining the message, adding personal touches, and ensuring the communication was truly impactful. This reframing helped the employee see the value of GenAI not as a replacement for their skills, but as a tool to enhance them.
  • Knowledge: Once the desire is there, employees need the knowledge to use Gemini effectively. This involves providing comprehensive training on the tool’s functionalities, best practices for prompting, and strategies for integrating it into their workflows. It’s about equipping them with the skills and understanding to truly leverage Gemini’s potential.
  • Ability: Knowledge is not enough; employees need the ability to apply what they’ve learned. This requires hands-on practice, opportunities for experimentation, and ongoing support. It’s about creating a safe environment where people can explore, make mistakes, and learn by doing.
  • Reinforcement: Finally, to ensure lasting adoption, reinforcement is key. This involves recognizing and rewarding successful use of Gemini, providing ongoing support and resources, and continuously communicating the benefits and impact of the tool. It’s about creating a culture where GenAI is seamlessly integrated into the way work gets done.

Addressing the “Assistant Mindset”

A key element of this change management process is helping employees embrace the “assistant mindset.” This means moving away from the idea that they need to do everything themselves and towards a collaborative approach where they leverage Gemini as a powerful ally. It’s about reframing their roles, recognizing that delegating tasks to Gemini can free them to focus on more strategic, creative, and fulfilling aspects of their work.

Mastering the Art of Prompting and Interaction

While generative AI tools like Gemini are incredibly powerful, their effectiveness hinges on our ability to communicate our needs and intentions clearly. This goes beyond simply typing in a text prompt; it’s about mastering the art of interaction and understanding the full range of ways to make the most of Gemini’s capabilities within Google Workspace.

Prompt Engineering: The Basics

Effective prompting is essential for getting the most out of Gemini. Here are a few key principles to keep in mind:

  • Be clear and specific: The more specific your instructions, the better the results. Instead of asking “write a training plan,” try “create a training plan for a new sales onboarding program, including modules on product knowledge, sales techniques, and company values. The plan should be structured for a 3-day program with a mix of presentations, role-playing activities, and online assessments.”
  • Provide context: Give Gemini the information it needs to understand your request. If you want it to summarize a document, provide the document or a link to it.
  • Experiment and iterate: Don’t be afraid to try different prompts and refine your approach based on the results. Prompt engineering is an iterative process.

Beyond Text Prompts: Unlocking Advanced Capabilities

But mastering Gemini goes beyond just text prompts. It’s about understanding how to fully utilize its potential within the Workspace environment. Here’s where things get really interesting:

  • The Gemini Side Panel: This powerful tool allows you to interact with Gemini in more sophisticated ways. You can drag and drop files, incorporate information from multiple sources, and apply Gemini’s analytical capabilities to generate insights and create new content. For example, I recently worked with a client who was impressed with Google Meet’s “take notes for me” and transcript features but found themselves spending significant time reformatting these into structured meeting minutes. I showed them how to use the Gemini Side Panel to combine three files – the meeting agenda, the Google Meet transcript, and an example of minutes from a previous meeting – and then use a prompt to generate new minutes from the transcript, formatted in the same way as the previous minutes. This saved them a huge amount of time and effort.
  • Contextual Awareness: Gemini is designed to understand the context of your work within Workspace. This means it can access and process information from your emails, documents, and other files, allowing for more intelligent and relevant responses.
  • Multimodal Interaction: Gemini is not just about text. It can also process images and potentially other forms of media in the future, opening up even more possibilities for creative expression and problem-solving.

By mastering these advanced interaction techniques, you can unlock the true power of Gemini and transform the way you work.

Looking Ahead: The Future of Work with GenAI

As we’ve seen, generative AI tools like Gemini have the potential to revolutionize the way we work. But the journey has just begun. One of the defining characteristics of this technology is its rapid pace of evolution. New features, capabilities, and ways of interacting with Gemini are emerging constantly. This presents both exciting opportunities and unique challenges for enterprises.

The Need for Continuous Learning

In this dynamic environment, continuous learning is no longer a luxury; it’s a necessity. Employees need to be equipped with the skills and mindset to adapt to new features and functionalities as they become available. Organizations need to foster a culture of continuous learning and provide ongoing support and resources to help their teams stay ahead of the curve.

This rapid evolution was evident in one of our recent pilot programs. At the start of the pilot, Gemini’s ability to analyse quantitative data in the Side Panel within Google Sheets was limited. However, just a few weeks in, Google pushed an update that significantly enhanced these capabilities. This step change opened up a whole new range of possibilities for our pilot participants, but it also highlighted the need for ongoing awareness and education around new features and functionalities.

Human-AI Collaboration: A New Era of Work

The future of work with GenAI is not about humans being replaced by machines; it’s about humans and AI collaborating to achieve more than ever before. This requires a shift in mindset, where we view AI as a partner that can augment our capabilities and free us to focus on higher-value tasks.

Imagine a future where:

  • Marketing teams use GenAI to brainstorm creative campaigns and generate compelling content.
  • Sales teams use GenAI to analyse customer data and personalize their outreach.
  • HR teams use GenAI to streamline recruitment processes and enhance employee engagement.
  • Engineering teams use GenAI to write and debug code, accelerating development cycles.

This collaborative future requires us to develop new skills, embrace new ways of working, and cultivate a mindset of continuous learning.

Responsible AI: Ethical Considerations

As we integrate GenAI into our workflows, it’s essential to consider the ethical implications and ensure responsible use of this powerful technology. This includes:

  • Data privacy and security: Protecting sensitive information and ensuring compliance with data protection regulations.
  • Bias mitigation: Being aware of potential biases in AI models and taking steps to mitigate their impact.
  • Transparency and explainability: Understanding how AI models arrive at their conclusions and ensuring transparency in their use.

This also extends to establishing clear guidelines and policies around the use of GenAI within the organization. In our pilot programs, we’ve been actively helping businesses explore these questions. For instance, in one organization, we facilitated a discussion around the feasibility of having a policy where any content or analysis generated with the assistance of Gemini was clearly noted in the document, presentation, or other output. This type of proactive policy-making can foster transparency, build trust, and ensure that GenAI is used ethically and responsibly.

By embracing these principles, we can harness the transformative power of GenAI while building a future of work that is both innovative and ethical.

Conclusion

The era of generative AI has arrived, and tools like Gemini for Google Workspace are poised to revolutionize the enterprise. But technology alone is not enough. To truly unlock the transformative potential of GenAI, organizations need to invest in change management, foster a culture of continuous learning, and embrace a collaborative approach to human-AI interaction. By doing so, they can empower their employees, enhance productivity, and shape a future of work that is both innovative and ethical.

The journey may be challenging, but the rewards are immense. Let’s embrace this new era of work with open minds, a willingness to learn, and a commitment to responsible AI practices. The future is collaborative, and it’s powered by generative AI.

Source: The Transformative Power of Generative AI: Reimagining the Enterprise with Gemini for Google Workspace

Google Apps Script now includes Google Drive API v3 support in the Advanced Services

If you closely follow the Google Workspace Apps Script Samples repo on GitHub (who doesn’t :) you might have spotted a recent commit which updates the Advanced Drive Services to v3.

The v3 of the Google Drive API has actually been around for a number of years launched on December 14, 2015. One of the reasons Google introduced version 3 was it came with performance improvements.

My impression is that the gap between the v2 and v3 has narrowed over the years with minor release updates, but there are still some areas where you can get more from the v3 API. One example reported by Kanshi Tanaike is to query Google Drive files by createdTime.

Google provide a Drive API v2 & v3 comparison guide, which highlights the main differences between the two versions of the API. To use v3 in your Apps Script project when you enable the Advanced Service for Drive you can select the version number.

Source: Drive API v2 & v3 comparison guide  |  Google Drive  |  Google for Developers

In-person Google Cloud Next ’23 MUST see: Getting the most out of Google Workspace with Apps Script, tips and tricks

In this session learn about combining APIs, automation, configuration as code, and more to improve your productivity using Google Workspace.

If you, or someone you know, is lucky to be at Google Cloud Next ’23 on Day 1 and would like a turbocharge to your Apps Script journey head down to the Moscone South, Lower Level and towards the Innovators Hive Theater for 11am as you’ll be in for a treat as Kara Ireland and Charles Maxson will let you know “How to get the most out of Google Workspace with Apps Script”.

I was part of a similar session at Next ’18 and it was great to meet in person new and established Apps Script users, many of them I’ still in touch with today. If you end up going say ‘hi’ to Kara and Charles from me.

Source: Getting the most out of Google Workspace with Apps Script, tips and tricks

Everything Google Workspace (and a little more) available online at Google Cloud Next ’23 Aug. 29-31, 2023

Next ’23 is our global exhibition of inspiration, innovation, and education. It’s where decision makers, developers, and anyone passionate about an accessible, scalable, socially responsible cloud come together to share challenges, solutions, 10x ideas, and game-changing technologies.

Google Cloud Next ’23 is just around the corner and if you are attending in person the Google Workspace Developer Relations team will be there in force giving various talk as well having a booth at the Innovator Hive. Chanel Greco has also put the call out to:

Bring your biggest smile for the community picture at our booth at the Innovators Hive:
📷 Day 1: 1PM
📸 Day 2: 11AM
😁 Day 3: 1PM

If you weren’t fortunate to snag a ticket to attend in person you can still register for complimentary access with a digital pass. I’ve also compiled the Everything Google Workspace (and a little more) playlist  of sessions that will be available online:

Project history/version history capability for Google Apps Script rolling out now!

NEW Apps Script Project History

The eagerly awaited project history capability for Google Apps Script in now rolling out. The feature is similar to the version history functionality found in other Google Workspace editors like Google Docs. As well as being able to see differences between the current and previous versions you can restore your script project to that point. Unlike Docs, Sheets and Slides there is currently no ability to ‘make a copy’ or ‘name a version’. My experience when using the Drive revisions data is that Google may merge revisions to save storage space.

No official news on the rollout of this feature other than reference to it in the What’s new for developers building solutions on Google Workspace – mid-year recap, posted in July 2023.

[Edit: Official update now posted in Google Workspace Updates]

H/T to my CTS colleague, Colin Birkett, for spotting this change.

AppSheet Core licenses will be included by default for more Google Workspace editions, along with a new Admin security setting

To bring the power of AppSheet to more users, AppSheet Core licenses will now be included for the following Google Workspace editions…

By including AppSheet Core licenses in more Google Workspace editions, the power of AppSheet is accessible to more users. Further, Admins will have the security features they need to ensure their users are using AppSheet appropriately in their organization.

Previously AppSheet Core licenses were included with Workspace Enterprise Plus, Enterprise Essentials Plus, and Education Plus users. Google have recently announced that AppSheet Core licenses will also be included in the following Google Workspace editions:

  • Business Starter, Standard, and Plus
  • Enterprise Starter and Standard
  • Frontline Starter and Standard
  • Non-profits
  • Education Standard

This is great news for Google Workspace users as AppSheet includes a number of out-of-the box features which already integrate into other Workspace products, like dynamic emails, Google Chat and Google Apps Script integration.

Along with the expansion of Workspace editions getting AppSheet Core, is the news that Admins will have basic security controls which can disable external usage of AppSheet apps.

Looking at the associated new security settings support page, it was interesting to see that turning on AppSheet Core security will disable ‘external integration through the app API’:

This caught my eye as the AppSheet API is a feature reported as only being supported on AppSheet Enterprise plans:

Perhaps it’s a mistake in the AppSheet API documentation, but I hope not as the AppSheet API is an incredibly useful addition for developers to do more with AppSheet.

Finally a little plug. If you are interested in AppSheet and would like to find out about training and support services get in touch. At CTS, where I work, we’ve a growing reputation in both products built using AppSheet as well as helping you get the most from the platform in your organisation.

Source: AppSheet Core licenses will be included by default for more Google Workspace editions, along with a new Admin security setting

Announcing: AppSheet Chat Apps now available to preview program!

We’re happy to announce that AppSheet-powered no-code chat apps are now available in preview for Workspace customers in AppSheet!

You can access this feature right now if you are in the Preview Program, and you can provide any feedback in this thread. If needed, additional information can be found in our help center articles. We’re targeting a full launch for later this year.

I’ve been spending a fair bit of time in Google’s ‘no-code’ platform AppSheet. Even for developers there is plenty to get your teeth into with features like Apps Script integration. One of the incredibly powerful core features of AppSheet is the ability to send dynamic emails which include forms designed in AppSheet. These allow users to interact with your app without leaving their inbox.

Whilst the inbox dominates in many business sectors, support for frontline workers increasingly leans on other communication channels including Google Chat. With the announcement of AppSheet powered no-code Google Chat apps there is now an opportunity to also push dynamic forms, send data and interact with Chat users in that space. For developers there is also the opportunity to do even more with the Apps Script integration. Follow the link to the announcement post to find out more…

Source: Announcing: AppSheet Chat Apps Now Available to Preview Program!

Highlights from the Google Workspace Developer Summit 2022 – The state of Workspace development is good!

Busy old couple of weeks at CTS and it’s been nice to get back to some face-to-face events. Last week I had the pleasure of joining the Google Workspace DevRel team on stage at the Google Workspace Developer Summit, London co-presenting with some guy called Charles Maxson.

A couple of years ago as part of Totally Unscripted we did a ‘State of Script‘ episode with then Apps Script PM Keith Einstein. This latest clip from the Google Workspace Developer YouTube channel captures not just the state of script, but the wider state of Workspace Dev.

The clip is worth a watch to get a summary of some of the new features coming to Workspace development. For me, not only is there plenty to get excited about my overall feeling from the Summit was Workspace development is now a first class citizen in the Google Cloud family. The state of Workspace development is good!

Source: Highlights from the Google Workspace Developer Summit 2022!

Introducing AppSheet databases: Build data driven apps for Google Workspace

Over the past year, we’ve added more functionality to AppSheet, extending how it can maximize the power of Google Workspace through integrations with products such as Gmail, Google Drive and Apps Script. To improve the experience for app creators and users, we’re excited to introduce in public preview AppSheet databases, a built-in database for citizen developers to easily and securely manage their data.

During public preview, access to AppSheet databases will be enabled by default for everyone but it will not affect existing apps. Use of this feature in public preview will be included at no additional cost in your AppSheet subscription plan, but limited to 10K rows per table, 20 tables per database and 20 databases per user. Please note that these limits may change when the feature is generally available.

For people who tuned in to TU3.5: New workflow solutions with Tables and Google Apps Script back in 2020 AppSheet databases will look very familiar. Since that episode the Area 120 team behind the Tables beta moved into Google Cloud and specifically AppSheet.

The big question for me is whether AppSheet databases can find a sweet spot for citizen developers looking for something with more performance than a Google Sheet and easier to setup than a Google Cloud project. In public preview AppSheet databases are limited to 10,000, which interestingly is the same limit as the old paid version of Tables.

Ultimately this may however be less able size and performance but a data solution that the AppSheet team has full control, particularly removing  a reliance on features developed by the Google Sheets team.

Source: Introducing AppSheet databases: Build data driven apps for Google Workspace

How Google Workspace is delivering innovation for the future of hybrid work | Google Cloud Blog

Google Workspace is the most popular productivity tool on the planet — relied on by more than 3 billion users. To help organizations thrive in a hybrid world, we’ve invested heavily in immersive connections, our approach to bringing people closer together through our communication products, and smart canvas, our next-generation collaboration experience, while enhancing our cloud-first security model to help people work safer.

Today is the first day of Google Cloud Next ’22 and this flagship event is being used to announce a number of upcoming features for Google Cloud and Workspace. This post (source link at the end) from the Google Cloud blog gives a summary of some of the key announcements including:

  • Bringing people together with immersive connections – which announces a number of new features being introduced to enhance Google Meet, the much requested feature to include inline threaded conversations in Google Chat as well as broadcast only Chat spaces
  • Collapsing the boundaries between people and apps with smart canvas – which highlights updates, mainly to Google Docs, to enhance productivity with custom building block and user defined variables. Google Sheets is also getting some smart chips enhancements including smart chips data extraction and third party integration as well as a new timeline view rolling out this month
  • Work safer with Google – a reiteration of Google’s commitment to security with updates on data loss prevention being extended to Google Chat, Trust rules in Drive and client side encryption for Gmail and Calendar
  • Extending the power of Workspace – the one perhaps of most interest to Pulse readers are the opportunities to build on Google Workspace with additional APIs for Meet and Chat, a Meet add-on SDK to third party integrations directly in Meet, and an official Google Chat integration from AppSheet apps.

For some of these announcements you’ll have to wait until 2023 at the earliest to get your hands on them. For a wider narrative and to see how the tech press is responding to today’s Google Cloud Next ’22 announcements here are some stories that have caught my eye:

Source: How Google Workspace is delivering innovation for the future of hybrid work | Google Cloud Blog