Every day you spend hours of your time sorting through emails to finish menial tasks like finding a client’s brief, approving vacation leaves and invoices, or putting leads to sales CRM. Imagine automating all these small repetitive processes without code. AppSheet’s new feature called AppSheet Dynamic Email allows you to create No Code automation right in your Gmail inbox. It is a step ahead in providing governance for citizen developers to build business apps faster.
You can interact with the app directly from your inbox. You can fill out forms, share documents and even add comments on someone’s work without leaving the inbox.
Explore the best of them with our free E-book and use tutorials to master these tools in a few minutes
Appsheet Dynamic Email is the new feature in AppSheet that allows you to send forms to Gmail users with embedded editable data fields. Whenever a user opens the email, they can directly interact with the app through Gmail without leaving their inbox. Real-time data is fetched by Google from an underlying data source when the email gets opened.
For example, if you receive an AppSheet form through Gmail, you can directly fill the survey from the inbox and your data will be collected and stored according to the conditions set by the sender. If the assigned database is a spreadsheet, they can create reports and generate analytics to measure different patterns and trends in their data.
Have a look at this travel request app created in Gmail:
Image credit: Google
Once you fill out the form with the details regarding your travel request, it directly goes to your manager’s inbox. They can approve it from their email itself and an automated email regarding their decision will be sent to you. Once you set up the automation, all of this would happen with just two clicks.
The first step is pretty obvious. Create an AppSheet account. Log in with the Gmail account that you are trying to automate. That would make things a lot simpler.
Create a new app or select the app you are working on, go to UX >> Options tab >> and toggle “Preview new features” on. Since Google recently launched this feature, you have to enable it from the dashboard yourself. They will probably deploy it as a default in the app in a couple of months.
Go to the Automation tab and create a bot. This bot can be deployed for an event (triggered when something happens) or to perform a set of tasks. Check this video to learn more about how to set up an AppSheet bot. For example, if you want to trigger the bot when someone fills your form, select “when request record is created” as the event.
Go to the editor on the right side of the dashboard and click on “Use Dynamic Email – Basic Form” to create an auto-generated form for your receivers.
Add details for the receiver, subject line, and the email body.
Preview the automation to test it out.
That’s it. You have successfully created your first Gmail automation through AppSheet. If you want to have a closer look at a detailed guide to Gmail AppSheet integration, you can check out this video[2]:
Here are the top 3 reasons why you should build No Code apps for your Gmail inbox automation.
Automating repetitive processes through AppSheet will lead to faster data flow and management. Let’s say someone fills a form for a tool demo. You will receive that data in sheets and will have to manually update it on the CRM or any other sales tool. But when you automate this process, your client will fill the form in their Gmail inbox and it will be directly uploaded to your CRM.
Inboxes get full of junk and unnecessary emails to a point beyond repair. It is important to keep it clean and organized so that you don’t miss out on any important emails. No Code apps give you an opportunity to manage your emails effectively with automation. You can leverage that to declutter your inbox.
All workflows are somehow attached to email communication. Whether it is amongst departments or with clients, Gmail always stays in the picture. Since employees will create apps and automation to solve a problem in their workflow, it will supercharge their day with productivity. They will have a more streamlined workflow and increased time for critical decision-making.
Google acquiring AppSheet was a huge milestone for the No Code movement. After that, the market of Appsheet got so huge that they announced a separate community for Appsheet Creators. Google has been expanding the boundaries of No Code development through its innovation. A lot of new details will be uncovered as they launch the new update. Drop by at our blog or Twitter for the latest No Code news, tips, and resources.
Explore the best of them with our free E-book and use tutorials to master these tools in a few minutes
Rokas Jurkėnas
For several years, I have been developing various products and systems using the No Code tools.
Choosing between Power Pages vs Power Apps depends on what you need. They serve different goals, and knowing their strengths can save you time. Here’s a clear...
Internal tools are essential for optimizing operations and improving collaboration. Choosing the right builder can make development hassle-free. This article covers the 10 best internal tool builders...
Power Apps and Power BI are both Microsoft tools. Power Apps lets you build apps without writing code. Power BI helps you analyze data and create reports....
Choosing a website builder can be overwhelming due to the many options. Drag-and-drop builders simplify the process, allowing anyone to design an entire website fast. Below are...
No code workflow automation tools help people create automated workflows without coding. They let you simplify tasks, save time, and increase productivity. In this guide, we’ll cover...
Choosing between LabVIEW vs MATLAB can be challenging. Each graphical programming language has unique data analysis, engineering, and automation strengths. We’ll explain the main differences and guide...
Visual Basic has been around for decades, but is it still worth learning in 2024? With modern programming languages and development tools, you may be wondering if...
Building your own dating app like Tinder may seem complex, but it’s achievable. This step-by-step guide will walk you through key features, development costs, and more. By...
Building a web app can feel complicated at first. But with the right tips and tools, anyone can create one. In this guide, we will cover the...
Choosing the right low-code platform can be challenging. In this article, we compare Mendix vs PowerApps to help you decide which is better for your project. Both...