Workflow Automation for Google Forms and Google Sheets

Workflow Automation for Google Forms and Google Sheets

Education Use Cases , General , How-To , zenphi Use Cases, , , ,

How do you remove the manual and mundane process of updating your spreadsheets? One way of doing that is by using Google Forms to Google Sheets automation. Boost Your Productivity with Forms to Sheets Automation Google Workspace hosts some of the most popular and well-loved digital productivity apps. And Google Forms and Google Sheets are …

Read more

How to Automate Your Google Apps Workflows for Faster Approval

General , How-To , zenphi Use Cases, , , ,

Google Workspace, formerly known as G Suite, was Google’s answer to Microsoft’s Office 365. Over the years, Google Workspace was able to establish itself as one of the well-loved productivity platforms out there — the over six million paying businesses that use Google Workspace out of the over two billion active users have spoken. Over …

Read more

Automating City Council Feedback/Complaint Workflow

How-To , zenphi Use Cases, , , ,

Every organization and establishment faces various challenges, and LGU offices and city councils are no exemption. These challenges were made even worse when COVID-19 hit and put the entire world at a standstill. It made us reconsider how we execute our daily operations. Public offices had to slow down even while work piles up. Local …

Read more

How to Import JSON Payload into Google Sheets

How-To , zenphi Use Cases, , , ,

When requesting data from APIs and other internet-based apps, it is given in the form of a Json payload. That payload will be in its static form containing the headers and the rest of the information you’ve requested. Whether you have encountered Json payload in the past or going to in the future, looking at …

Read more

Automating Your Incident Report Workflow on Google Workspace

How-To , HR Use Cases , Legal Use Cases , zenphi Use Cases, , , ,

Automating incident report workflow on G Suite can bring you a lot of advantages. Incidents happen in and around the workplace. And when they do, it is bound to interrupt some parts of your business operation. Incidents also may or may not incur injury or loss and/or damage to company property. The former may lead …

Read more

How to Use the Google Sheets Lookup Row(s) Action

General , How-To , zenphi Use Cases, , , ,

When automating our workflows on Google Workspace, we heavily rely on Google Sheets to store data and also to lookup reference data. Say you want to look up customer information by customer id. We usually store customer information in a sheet and will need to scan through the Id column to find a match. The …

Read more

Dynamically Generate Google Slide Using Google Sheets Data and Export it to PDF

How-To , zenphi Use Cases, , , ,

Automatically turning a set of data from one file to another can save you and your team untold amounts of time, not to mention how it will innovate and speed up several areas of your daily operations. Data entry is such a huge part of every business. That is why it is no surprise for …

Read more

Automating Your Document Approval Workflow

How-To , Legal Use Cases , Marketing Use Cases , zenphi Use Cases, , ,

In a business setting, one of the most frequent and recurring tasks that you can observe is document approval. As a zenphi content writer, it is my daily task to draft our blog post and request my editor’s approval.  This used to be one of our most tedious processes with one too many back and …

Read more

Automate Your Supplier Invoice Approval Workflow on Google Workspace

How-To , Sales Use Cases , zenphi Use Cases, , ,

Supplier invoicing is one of the many and recurring business processes that take place in a business setting. AccountingTools define supplier invoice as: “The bill issued by a vendor for goods delivered or services rendered to a customer. The recipient of a supplier invoice issues its own invoices to its customers, and so may refer …

Read more