Google Sheets add-on

Letting Your Business Thrive Amidst COVID-19

No comments

Putting up a business can be both exhilarating and challenging. Consider Maria, who recently organized a team of fitness professionals. She’s fulfilling a life-long dream of spreading the benefits of health and wellness by creating personalized programs for clients. However, Maria’s months of planning was threatened to be shelved when the COVID-19 pandemic hit.

Ever the optimist, her team embarked on moving their operations online. They’ve refocused to bank on the wide reach of the Internet in providing their services. As a G Suite user, make the most of the native apps (Docs, Sheet, Form) by using these to manage your processes. Here are essential tips in making your business thrive in the midst of the COVID-19 pandemic:

Establish your online presence with a regular stream of promotional contents

Take advantage of social media, blogs, vlogs, and newsletters. It helps to plan ahead by scheduling a lineup of contents. In Maria’s case, she created a team of editors and established an approval process for queuing topics for publication. They’ve set to the task of promoting their advocacies paired with activities that can be done at home. These were opportunities to send out offers to potential customers regarding their health and wellness services.

A workflow app such as Form Workflow Plus helped automate their approval process for online contents. Its ease of setup allowed Maria’s team to focus more on fleshing out ideas instead of devoting hours manually managing requests. At the end of the day, the add-on helped track which ideas were approved then queue them for publication.

Form Workflow Plus offers a 14-day free trial. Sign up here.

Reach out with a personal touch

This pandemic has forced people to shy away from crowds and face to face interactions. Take this opportunity to deliver messages of assurance. Highlight how your business can bridge physical and emotional gaps.

For Maria, she emphasized the importance of providing personalized wellness programs. Her newsletters provided practical tips and offered their services via video conference calls.

Engage your potential clients to generate a buzz around your products or services

With the wide range of smartphones and compact cameras, creating personal videos has never been easier. These can be published on social media sites such as Facebook or YouTube to reach a wider audience. Use these channels to create short videos highlighting product features and personal anecdotes.

For Maria, her team prepared 5-minute exercises that were easy to follow. They also prepared a series of chair yoga poses for those working at home.

The next step was to host webinars to promote health and wellness while on lockdown. These sessions paved the way to web-hosted group exercises. To add a personal touch to their customer communications, they used G Merge Plus in sending out invitations. This add-on also helped Maria’s team create personalized certificates of participation for the attendees.

G Merge Plus offers a free trial. You can sign up here.

For Maria’s team, customers began signing up for their personalized programs. Through word of mouth referrals and their quality online contents, Maria’s business was able to survive and even thrive amidst the pandemic.

If you’re a business owner whose operations recently moved to the cloud, Form Workflow Plus and G Merge Plus can help you. Book a demo today:

Marko ArcegaLetting Your Business Thrive Amidst COVID-19
Read more

Managing Contractor Timesheet Approvals with Form Workflow Plus and G Merge Plus

No comments

The global reach of the Internet has allowed for a paradigm shift in the way people work. Service contractors thrive in freelance works as they enjoy the perks of flexible hours and freedom from the four corners of an office cubicle. Dubbed digital nomads, they belong to a pool of multi-talented individuals who can easily adapt to the ever-changing technological landscape.

Managers who supervise these service contractors also face novel challenges. Consider Tom, who founded a company for an online marketplace based in New York. He has outsourced a majority of the development work and website management to John, a service contractor based in Thailand. Besides dealing with the physical distance, Tom has to keep track of timely service delivery. More importantly, Toms needs an accurate means of keeping track of the hours John has put in and invoiced each month.

This is where a workflow app such as Form Workflow Plus can help Tom provide a transparent and automated validation process for John’s timesheet approvals. After installing the add-on from the G Suite marketplace, Tom was able to focus his time and efforts on company growth knowing John is properly compensated. Businesswise, Tom cut costs as there’s no longer a need to buy expensive time management tools. With G Suite, everything can be automated.

Using Form Workflow Plus, here are important tips on how Tom was able to achieve success:

1. Prepare a worksheet for contractors to log the number of hours worked

In line with digitizing processes, managers can use online tools such as Google Sheets for this purpose. This promotes a relationship built on transparency and sets the stage for quick resolution should any dispute arise.

Create a worksheet template which contractors can modify. Here’s a sample:

At the very least, the worksheet should have:

  • Sheet title set to contractor name
  • Use the same template for each month and place in individual sheets
  • Daily logs of hours worked broken down into specific projects
  • Tally of total hours worked with hourly rate factored in

2. Create a Google Form to collect timesheet approval requests

At the end of each month, John submits this timesheet for approval. Create a validation process to ensure accuracy which can include the team leader, area manager, and finance department as reviewers.

An effective form should capture:

  • The contractor name and/or number
  • The inclusive month for the timesheet
  • Email address
  • Link to the digital timesheet
  • Quick overview of total hours worked

3. Setup an approval process to check for accuracy and establish an audit trail

Form Workflow Plus can automate the validation process on your behalf. The following features make the product great at managing workflows:

  • Easy one-time setup
  • Handles multi-step approvals
  • Conditional approvals for routing requests based on specific criteria
  • Web application for managing workflows, users, and billing

Form Workflow Plus has a 14-day free trial. Sign up here.

The form responses above can be collected on a Google Sheet where, in turn, Form Workflow Plus is activated as an add-on. Here’s a sample sheet collecting the above information:

Setting up a workflow is easy! We prepared a guide for you:

4. Use a document and mail merge app to automate invoice creation for approved requests

WIzy’s G Merge Plus is also a Google Sheets add-on that can create personalized invoices based on a template. On top of this, each created document can be emailed out as part of its mail merge feature. This is useful in case the Finance Team or Accounting Department needs to be notified. Here are some of the reasons G Merge Plus would be a perfect complement to timesheet approvals:

  • Works on Google Sheet so it can be activated on the same Form Workflow Plus worksheet
  • Can be set with filters to process rows of data marked “Approved”
  • Automates the merge process by using an invoice template
  • Can be set to send the merged documents as attachments using the mail merge feature
  • Has a drag-n-drop email editor for creating content-rich email templates
  • Try for free! Sign up here.

Read more about G Merge Plus’s features here:

For questions, Form Workflow Plus and G Merge Plus both come with a dedicated support team at support@wizy.io. Set a demo via this link:

Marko ArcegaManaging Contractor Timesheet Approvals with Form Workflow Plus and G Merge Plus
Read more

Managing Teaching Loads with Form Workflow Plus

No comments

Schools and universities are among the early adopters of cloud-based solutions. This proves important as these institutions move towards remote collaboration and holding classes online. Easing into digital processes may prove daunting for school administrators. With Form Workflow Plus, this doesn’t have to be the case. Wizy has designed this app to help automate validation processes.

Let’s take a look at Jane, a supervisor managing teaching loads in a university. They have a teaching program where post-grad students need to teach a particular subject per term. Jane oversees the approval process and keeps track of the subject assignments. They have recently moved towards reducing their carbon footprint by adapting paperless technologies for their workflows. This proved prescient as the ensuing COVID-19 pandemic forced educational institutions to fast track their transition into the cloud.

For Jane, an email-based approval process simply can’t cope with the number of requests. Also, manually tracking approved requests also means countless hours of manual and repetitive data entry tasks. Jane realized the benefits of using a workflow app when she found Form Workflow Plus in the G Suite Marketplace.

Here we explore how Form Workflow Plus can help manage teaching load requests. School administrators can greatly benefit from using this workflow app by easily keeping track of subject assignments for the upcoming term. For universities that have teaching programs similar to Jane’s this guide comes in handy. Here are tips to ensure success:

Capture the essentials via Google Form and Sheet

Make sure reviewers have the necessary details to make informed decisions. Your request form can include the following:

  • Teacher details – Name, email address, student/employee number
  • Course description – Course title, course code, brief description of the subject
  • Inclusive term – This could include the specific semester or term
  • Department details – This includes the specific department the teacher belongs to, department head contact information
  • Supporting documentation

Google Forms collect responses on a Google Sheet. Form Workflow Plus, as a Google Sheet add-on, facilitates automation of the approval process. Did I mention we offer free trial and 40% discount for schools? Head over here to learn more.

Let Form Workflow Plus do its magic

Our workflow application works with G Suite and can easily accommodate single to multi-step approval processes. Admins set it up once and requests are routed automatically upon form submission.

  • Take advantage of conditional approvals

Wouldn’t it be great if requests can be automatically sorted depending on the originating department, course number, or via admin-set criteria? With Form Workflow Plus, you can! This greatly speeds up the approval process and more importantly, takes the burden of manual tasks off of school admins.

Requesters can even specify their preferred reviewer and Form Workflow Plus will take care of the rest.

  • Easily track request status

Workflow admins gain a quick oversight via the worksheet or on the web app. A Reports view is included to easily be on top of your request stats.

  • Work with a versatile web application

Form Workflow Plus comes with a web app for managing workflows, billing, and setting user roles. It’s a one-stop repository of the team’s Forms as well. Approvals view allows reviewers quick access to pending requests.

Getting Started

Dive deeper into the workflow creation process:

Learn more about conditional approvals in these guides:

Help is just a click away should things get too complicated

Form Workflow Plus is a complete solution package and comes with a comprehensive Help Center. Tap into detailed how-to articles and specific FAQs to fully maximize the add-on’s features. For everything else, support@wizy.io is just an email away. Feel free to book a demo here:

Try For Free

Marko ArcegaManaging Teaching Loads with Form Workflow Plus
Read more