How to create and send an envelope from a template in DocuSign when a Google Sheet is updated

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

Creating contracts involves a lot of important information and is one of the tasks where input errors are not allowed.
By utilizing Yoom and integrating Google Sheets with DocuSign, you can automate the process of creating and sending contracts.
This allows you to reduce manual errors and create an environment where you can focus on important tasks.
This article provides a detailed explanation of how to automate contract creation and document sending tasks without the need for programming.

Recommended for

・Those who want to use Google Sheets for data management and streamline contract creation
・Sales representatives who feel burdened by manual contract creation and sending tasks and are considering automation
・Those who use Google Sheets for managing customer information
・Those who want to streamline routine contract tasks with DocuSign and reduce workload
・IT personnel who want to achieve business automation by linking Google Sheets and DocuSign using API integration

Benefits and Examples of Integrating Google Sheets and DocuSign

1: Reduction of Work Time

By implementing this flow, every time Google Sheets is updated, DocuSign automatically creates and sends envelopes (signature requests) based on templates, eliminating the need for manual contract preparation and sending.
For example, you can build a system where the sales team only needs to enter a new customer list into Google Sheets, and contracts are immediately sent to customers.
This automation may reduce the work time of personnel involved in the contract process, allowing them to focus more on important tasks.

2: Prevention of Human Error

When preparing contracts manually, data entry errors such as names and addresses can inevitably occur.
By directly linking data from Google Sheets to DocuSign templates, you can minimize input errors and deficiencies.
For instance, by automatically importing information recorded in contracts from Google Sheets, you can prevent input and transcription errors such as incorrect addresses.
You can send the correct content, potentially reducing inquiries and correction work from customers or partners.

3: Burden Reduction Through Automation of Repetitive Tasks

Automating routine contract tasks that are repeated daily can also lead to a reduction in staff burden.
For example, some organizations regularly send consent forms or contracts.
By utilizing the integration of Google Sheets and DocuSign in such situations, the person in charge no longer needs to manually create documents each time, allowing time to be allocated to other resources, potentially increasing the productivity of the entire department or team.

[What is Yoom]

Now, let's actually create a flowbot using the template "Create and send envelopes from a template with DocuSign when Google Sheets is updated".

How to Create a Flow for Integrating Google Sheets and DocuSign

The process to complete the flow will proceed as follows:

・Integrate Google Sheets and DocuSign with My Apps
・Copy the template
・Set triggers in Google Sheets and configure operations in DocuSign
・Turn on the trigger and confirm the actual activation

Now, let's proceed with the new connection of the apps to be integrated.

・Integrate Google Sheets and DocuSign with My Apps

(1) First, connect Google Sheets to My Apps.
After logging into your Yoom account, click "My Apps" on the left panel and search for Google Sheets from "New Connection".

‍

‍

Search for and click on the Google Sheets app icon.

‍

‍

‍

(2) Click "Sign in with Google" to transition to the account selection screen, and choose the account you want to integrate from the right management account.
After selection, transition to the sign-in screen and complete the authentication.
The first Google Sheets connection is now complete.

(3) Next, let's connect DocuSign.
Search for the app in the same way as the new connection for Google Sheets.
When the following screen appears, enter your email address and log in.

‍

‍

Now, both apps are connected to your Yoom account.

・Copy the Template

(1) After confirming that the new connection of the target app is complete in your Yoom account, click the icon for "Try this template" below.

‍

(2) The template will be copied, so click the "OK" button.
You will be taken to the "My Projects" screen of your Yoom account, so please check the template content.

‍

‍

There are two setup flows.

・Google Sheets Trigger Setup

(1) First, set up the Google Sheets app trigger.

‍

‍

From the "My Projects" on the left side of your Yoom account screen, click "【Copy】Create and send an envelope from a template with DocuSign when Google Sheets is updated".

‍

‍

After clicking, the template content will be displayed as shown in the screen below.

‍

‍

(2) Click on the trigger "When a row is updated".

‍

‍

(3) Enter the account information to be linked and click [Next].
On the next screen, enter information such as "Trigger Interval" and "Spreadsheet ID".

Select any of the following for "Trigger Interval": 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*Note that the trigger interval varies depending on the plan.

‍

‍

(4) For the "Spreadsheet ID" and "Sheet ID" fields, click the input bar to expand the information obtained from the account as "candidates" as shown in the screen below.
Let's also make use of this information.

‍

‍

(5) Fill in the other fields as well.
This time, we have set the "Check Item in Column E" of Google Sheets as the [Column to Detect Updates].
The image is "Activate Flowbot when the check item in column E is updated".

‍

(6) After entering the information, click [Test], and if there are no problems, click [Save].

In this step, you can obtain information as output as shown below.
As noted, "You can use this value in other operations," you can reference and utilize it in subsequent steps.

‍

‍

・DocuSign Setup

(1) Next, click on the second action "Create and send an envelope from a template".

‍

‍

(2) Enter the account information for the DocuSign to be linked and click [Next].

‍

‍

(3) On the next screen, enter the "Account ID" that can be confirmed from the person icon at the top right of DocuSign.
The "Template ID" can be referenced from the 'candidates' that expand after clicking the input bar.

‍

(4) For the "Recipient" field, you can set the "Recipient's Email Address" by referencing the output obtained from the previous step, as shown in the screen below.

‍

‍

(5) For "Whether to send", select 'Send' from the dropdown.

‍

‍

(6) After entering the information, click [Test], and if there are no problems, click [Save].
This completes the setup.

・Turn on the Trigger

‍

By clicking the red-framed "Turn on Trigger" part of the screen below, the flowbot will start automatically.

‍

‍

Here is the template used this time

Other Automation Examples Using Google Sheets

There are other examples of automation using Google Sheets on Yoom, so here are a few introductions.

Update Google Sheets Information When a Contract is Completed in DocuSign

This flow automatically adds the sending date and time to the registration information in Google Sheets when a contract is completed in DocuSign.
Automation eliminates the time previously spent on data entry, allowing the entire team to focus on important tasks.

Add to Google Spreadsheet when a contract is completed in DocuSign

When a contract is completed in DocuSign, it is automatically added to the Google Spreadsheet database.
Automation saves the time previously spent on data entry, allowing the entire team to focus on important tasks.

Send an Email with Gmail When a Row is Updated in Google Sheets

This flow is recommended for those who want to automate notifications of additional information in Google Sheets.
When a row is updated in Google Sheets, an email can be automatically sent via Gmail, making it easier to understand the updates and allowing the team to proceed with a unified understanding of the tasks.

Summary

By integrating Google Sheets and DocuSign, the automation of the process from contract creation to sending can be achieved, leading to reduced working time and minimized human errors.
By streamlining repetitive contract tasks, staff can focus on other important tasks, potentially increasing the overall productivity of the organization.

Please take advantage of Yoom to experience automation through app integration.