Mastering Google Sheets Workflow Integration: Top Tips For Success!

Name: Mastering Google Sheets Workflow Integration: Top Tips For Success!
Uploaded: 2023-07-25T16:00:20.000Z
Duration: 1 h 8 min 41 s

Introduction

In this section, Ray O'Daniel introduces the topic of the video and mentions that he will be focusing on Google Sheets as a premium workflow action in High Level.

Introduction to Google Sheets in High Level

Ray O'Daniel introduces the topic of the video and mentions that he will be focusing on Google Sheets as a premium workflow action in High Level.

He highlights that Google Sheets can be used for various cool features within High Level.

Ray encourages viewers to subscribe to his channel and use his affiliate link if they are interested in signing up for High Level.

Overview of Google Sheets

In this section, Ray provides an overview of a sample Google Sheet called "Sales Report" and explains the importance of having headers in your Google Sheets when working with High Level.

Understanding Headers in Google Sheets

Ray shows a sample Google Sheet called "Sales Report" which includes columns such as first name, last name, company name, sales associate, sales date, and sales amount.

He emphasizes that it is crucial to have at least one row of headers in your Google Sheets when using High Level.

Headers help High Level identify the data correctly and ensure smooth integration with your workflows.

Practical Examples with Google Sheets

In this section, Ray discusses practical examples of using Google Sheets within High Level and demonstrates how to update sales amounts based on opportunities.

Updating Sales Amounts with Opportunities

Ray explains that he will demonstrate how to update sales amounts inside the Google Sheet based on opportunities in High Level.

He mentions that there is no standard place to store sales amounts in High Level, so creating a custom field is necessary.

Ray navigates to the settings and custom fields section in High Level to create a custom field for sales amount.

He creates a monetary value custom field called "Last Sales Amount" to store the sales amounts.

Conclusion

In this section, Ray concludes the video by summarizing the importance of using Google Sheets in High Level and creating custom fields for specific data.

Summary and Final Thoughts

Ray emphasizes that Google Sheets can be a powerful tool within High Level for various use cases.

He highlights the significance of creating custom fields, such as the sales amount field, to store specific data.

Ray thanks viewers for their support and encourages them to explore more features in High Level.

The transcript provided does not cover the entire video.

New Section

In this section, the speaker discusses the need to update a custom field in an opportunity to store the last sales amount. However, they highlight that this approach only captures the last sale and does not provide a history of sales amounts.

Updating Custom Field for Last Sales Amount

The speaker suggests updating a custom field in the opportunity to store the last sales amount.

This allows users to have a placeholder indicating the most recent purchase made by a contact.

However, it is important to note that this approach only captures the last sale and does not provide a history of sales amounts.

New Section

In this section, the speaker explains how a workflow can be triggered when an opportunity status changes and how it can update the custom field for the last sales amount.

Triggering Workflow on Opportunity Status Change

When an opportunity status changes, a workflow can be triggered.

The workflow will update the custom field for the last sales amount with the lead value associated with that particular opportunity.

This ensures that whenever an opportunity moves to status one (indicating a win), the last sales amount is updated accordingly.

New Section

Here, we learn about updating contact records using workflows and how to configure them to update the last sales amount based on lead values.

Configuring Workflow to Update Contact Record

To update contact records using workflows, we need to select "Update Contact Field" action.

We then choose the custom field for "Last Sales Amount" as our target field.

By replacing "Opportunity" with "Lead Value," we ensure that this field gets updated with each new lead value associated with opportunities.

After configuring these settings, we save and publish our workflow.

New Section

In this section, the speaker demonstrates how to move an opportunity to status one, triggering the workflow and updating the last sales amount in the contact record.

Moving Opportunity to Status One

To trigger the workflow and update the last sales amount, we need to move an opportunity from its current status to status one.

This action simulates a win or a customer acquisition in our business process.

Once the opportunity is moved, the workflow will be triggered, and the last sales amount will be updated in the contact record.

This updated data can then be used for further analysis or reporting purposes.

New Section

Here, we see how to manually move an opportunity into a specific column within a pipeline.

Manually Moving Opportunities

To manually move an opportunity within a pipeline, we locate the desired opportunity and drag it into the desired column.

By doing so, we can control which stage of our sales process each opportunity is in.

The transcript does not provide any additional sections beyond this point.

New Section

This section discusses the process of setting up a workflow and using Google Sheets in the sales pipeline.

Setting Up the Workflow Trigger

To set up the workflow trigger, navigate to the pipeline one status.

Add a step to update the contact field information.

Go to the workflow section and add a new workflow called "Google Sheets."

Save the changes.

Allowing Re-entry in Pipeline One Status

It is important to allow for re-entry in the pipeline one status if you expect contacts to go through the workflow multiple times.

In settings, enable "Allow for re-entry" so that contacts can enter the workflow more than once.

Using Google Sheets Actions

In the Google Sheets workflow, there are various actions available.

You can create a spreadsheet row, look up a specific row, update rows using lookup functions, and delete rows.

New Section

This section focuses on updating rows in Google Sheets using lookup functions.

Updating Rows with Lookup Function

The "Update Row Using Lookup" action allows you to find a specific row based on certain criteria.

Use this action when you want to update specific rows in your Google Sheet based on lookup values.

New Section - (Language: Non-English)

This section is not available as it contains non-English content.

Using the Lookup Spreadsheet Row

In this section, the speaker explains how to use the lookup spreadsheet row function in Google Sheets to retrieve data from a spreadsheet and make it available for other functions.

Retrieving Data with Lookup Spreadsheet Row

The lookup spreadsheet row function allows you to find specific rows in a spreadsheet and pull that data back.

This data can then be used by other functions within Google Sheets.

To use this function, you need to go through and use the lookup spreadsheet row in your workflow.

Exploring Different Use Cases

The speaker mentions that there are multiple ways to utilize this function in your business.

They provide examples but note that it ultimately depends on how you want to utilize it.

Connecting to Google Drive

To access the desired spreadsheet, you need to connect your Google account with integrations.

Once connected, the function will be able to access your Google Drive where the spreadsheet is stored.

Creating a Sales Report Spreadsheet

The speaker demonstrates creating a sales report spreadsheet stored in their Google Drive.

They create a sheet named "Sheet 1" and specify the start and ending columns for updating data.

Updating Data Fields

When using the workflow, contact information from a person in the sales pipeline opportunity will flow into this process.

Various fields such as contact first name, last name, company, etc., can be easily updated using this function.

The sales associate's user account can also be associated with the opportunity.

The sales date can be set based on different criteria like appointment dates or current date of execution.

The sales amount field can be populated using custom fields created for storing previous sales amounts.

Manually Kicking Off Workflows

Due to previously fired workflows, manual initiation is required for this particular workflow stage.

The speaker mentions that they will have to manually kick off the workflow in stages.

Manually Initiating the Workflow

In this section, the speaker explains the need for manual initiation of the workflow and demonstrates how to do it.

Manual Initiation Process

The speaker mentions that since they already fired a previous workflow, this one needs to be manually initiated.

They demonstrate scrolling through the context and show that there are 11 records present.

Continuing with Manual Initiation

In this section, the speaker continues with the manual initiation process and provides further instructions.

Navigating to Context

The speaker states that they will continue by going into the context for further steps.

Using Google Sheets for Workflow

In this section, the speaker demonstrates how to use Google Sheets for workflow management.

Demo: Adding to Campaign

The speaker explains that they will be using a Google Sheet for the workflow.

They demonstrate adding a record to the campaign by clicking "OK."

The speaker mentions the importance of allowing re-entry in order to avoid damaging the presentation.

Updating Records in Google Sheets

The speaker goes back to Google Sheets and enables re-entry in the settings.

They explain that not enabling re-entry can cause issues if running the same update multiple times.

The number of records before the update was 11.

There are technical difficulties encountered while trying to demonstrate further updates.

Another record is added with the name "Jane Smith" and assigned to "Total Relief Massage."

Although no user is assigned, the date and sales amount are set correctly.

Using Lookup Function in Google Sheets

The speaker introduces the lookup function in Google Sheets.

They navigate back to their spreadsheet and select sheet one.

It is mentioned that you can search from either the top or bottom of the sheet, but it doesn't affect much.

A lookup column is chosen, such as "first name," and linked with "contact first name."

This allows looking up all records for a specific person, like Jane Smith.

Update Spreadsheet Using Lookup

The speaker demonstrates updating a spreadsheet using lookup.

They mention that you can find specific records for a person and make updates if needed.

Multiple lookups can be used, but it's important to specify which data set you want to work with.

Exploring More Features in Google Sheets

In this section, additional features of Google Sheets are explored.

Other Actions in Google Sheets

The speaker introduces the "update spreadsheet using lookup" action.

This allows finding specific records and updating them.

The importance of specifying the correct step for lookup is emphasized.

Conclusion

The speaker concludes by mentioning that these features provide examples of how Google Sheets can be used for workflow management.

Timestamps are provided in seconds to link to the corresponding part of the video.

Understanding Column Organization

In this section, the speaker discusses the importance of understanding column organization when updating records in a spreadsheet.

Starting and Ending Columns

The starting column determines where the update process begins.

The ending column determines the last column to be updated.

Updating Specific Columns

When updating records, it is crucial to consider the headers and how the sheet is organized.

Only columns that are included in the update process will be affected.

Populating Values for Updates

To update a specific column, all preceding columns must be populated with values. Otherwise, the record will be blanked out.

It is essential to include all necessary values for accurate updates. Leaving any value blank may result in its removal from the record.

Selecting Specific Columns for Update

This section focuses on selecting specific columns for updates and demonstrates how to choose and update individual columns.

Choosing Columns for Update

Depending on the requirements, specific columns can be selected for updates while leaving others unchanged.

For example, if only the sales associate needs to be updated, only that column should be modified while keeping other fields intact.

Updating Sales Associate Column

To update the sales associate column manually, enter their name directly into the corresponding cell and save changes.

Other columns like contact first name, last name, and company name can also be updated using similar steps.

Correcting Mistakes and Updating Sales Associate

This section covers correcting mistakes made during the update process and demonstrates how to update the sales associate column correctly.

Rectifying Mistakes

If a mistake is made during the update, it can be rectified by selecting the correct starting and ending columns.

It is important to double-check before proceeding to avoid unnecessary errors.

Updating Sales Associate Column

To update the sales associate column, enter the desired name in the corresponding cell and save changes.

Ensure that all necessary values are entered correctly to prevent any unintended removal of data from the record.

Reentry and Manual Workflow Kickoff

This section discusses reentry into workflows and manually initiating workflow kickoffs.

Allowing Reentry

By allowing reentry, workflows can be initiated manually for the same user multiple times.

This enables specific values to be set or updated as required.

Manually Initiating Workflow Kickoff

To manually initiate a workflow kickoff, select the user, choose Google Sheet, specify relevant details like demo and campaign, and proceed with execution.

Check the workflow status in Google Sheets' enrollment history to ensure successful execution.

Updating Spreadsheet Using Lookup

In this section, we learn about updating spreadsheets using lookup functionality.

Update Using Lookup

Utilize lookup functionality to update specific values in a spreadsheet without affecting other records.

This allows for targeted updates based on specific criteria.

Example Update

An example demonstrates how the sales associate column is updated for a particular record using lookup functionality.

Only the intended record is modified, leaving other records unaffected.

Updating Records in Google Sheets

In this section, the speaker demonstrates how to update records in Google Sheets using a lookup function.

Using Lookup to Update Records

Use a lookup function to find a person's name in the contact record and update the corresponding amount.

Note that only the first record is updated.

Deleting Actions

Delete unnecessary actions to avoid repetition.

Utilizing Lookup in Google Sheets

Use the lookup function in Google Sheets to delete specific rows.

Save the changes made.

Executing Lookup and Deletion

When executed, the system will look up a person's name and delete the corresponding row.

Testing with Different Data

Test with different names, such as "James Smith," to see how the workflow functions.

The first record that matches will be deleted.

Understanding Changes in Google Sheets

The updated record will be removed from view.

Blank records may appear instead of completely removing lines from Google Sheets.

Precautions and Testing

Before implementing these actions live, make sure to create a copy of your spreadsheet for testing purposes.

Avoid testing with live data; use demo data instead.

Make sure all actions perform as expected before proceeding further.

Additional Actions in Google Sheets

This section covers additional actions that can be performed in Google Sheets, such as creating, looking up, and deleting specific rows.

Creating and Updating Specific Rows

Choose an account (e.g., My Drive) and select a sales report sheet.

Enter a row number for updating or deleting specific rows.

Challenges with Row Numbers

Finding an example for utilizing row numbers is difficult.

Consider creating custom fields or storing customer contact records for better utilization of row numbers based on specific scenarios.

Deleting Specific Rows

Similar to updating, select the desired drive and specify the row number to delete.

Row numbers play a significant role in this action.

Exploring Row Numbers

Use a lookup function to find the row number associated with a specific name (e.g., James Smith).

This can help determine which row to update or delete.

Summary

In this transcript, the speaker demonstrates how to update and delete records in Google Sheets using lookup functions. The process involves finding specific names in contact records and performing actions based on those findings. It is important to test these actions thoroughly before implementing them live, using demo data instead of live data. Additionally, challenges may arise when working with row numbers, but custom fields and creative solutions can help overcome these obstacles.

[t=0:29:09s] Using Google Sheets Lookup for Row Numbers

In this section, the speaker discusses how to use Google Sheets lookup to store and access row numbers for specific data entries.

Storing Row Numbers with Lookup

A placeholder value is needed to store the row number for a particular person in a specific row.

The speaker mentions using automation in Google Sheets to achieve this.

The lookup feature allows accessing information from a specific row, but it's unclear if the row number itself can be accessed.

Demonstrating the Process

The speaker admits not having much experience with Google Sheets personally but aims to demonstrate its utilization.

They update the contact field and choose the custom field "Sales report row number" as an example.

Clicking on this value should provide access to the Google Sheet lookup.

Accessing Row Numbers

The Google Sheet lookup retrieves data from a previously pulled report.

By examining the retrieved data, including contact first names, it becomes apparent that row numbers can be obtained through lookup.

Integrating Row Numbers

After obtaining the row number from the lookup, it can be integrated into other processes.

The speaker demonstrates integrating by updating a contact record with Jane Smith's row number (row 12).

This allows future access and manipulation of data based on specific rows.

Limitations and Considerations

It is mentioned that certain scenarios may pose challenges when dealing with multiple records for a customer.

Despite potential limitations, having access to row numbers provides valuable flexibility for updating or deleting rows in the future.

[t=0:33:00s] Conclusion and Application of Google Sheets Premium Actions

In this final section, the speaker concludes by summarizing key points about utilizing Google Sheets premium actions and encourages viewers to explore integration possibilities within their own businesses or workflows.

Recap of Features

The speaker acknowledges that the video may not be flawless but aims to showcase Google Sheets' features and premium actions.

They emphasize the ability to integrate these actions into pipelines or sales calendar appointments, facilitating efficient data management.

Sparking Ideas for Integration

The goal is to inspire viewers with ideas on how they can leverage Google Sheets and premium actions in their own businesses.

Examples include integrating with pipelines or updating contact records based on row numbers.

Encouragement for Exploration

The speaker encourages viewers to explore the possibilities of using Google Sheets premium actions within their specific workflows.

By understanding row numbers and utilizing lookup functions, users can enhance their data management processes.

Timestamps are provided in [t=HH:MM:SSs] format.

Did you win the bid?

The speaker discusses the outcome of a bid and how pipelines are used to keep in contact with leads.

Working from a Pipeline Perspective

Most people use pipelines to keep in contact with their leads.

Moving Leads to One Status

When a sale is made, the lead is moved to a one status, and other actions can be executed after that.

Engagement and Support

The speaker encourages engagement and support from viewers.

If you liked the video, click on the like button below.

Leave a comment, whether it's good, bad, or ugly. The speaker appreciates all feedback.

The speaker is creating videos for viewers and requests support by using their affiliate link when signing up for high-level plans.

Subscribing to the channel is encouraged. Click on the subscribe button if not already subscribed.

The speaker expresses gratitude for hanging in there and wishes everyone a great day.

Learn More About High Level

Information about learning more about High Level and available courses.

Click on the link below for a free High Level course that covers account creation, setup, and getting started within two days. A snapshot offer is also available when signing up with High Level through the speaker.

A client onboarding course is offered that can be used by clients or to train teams in client onboarding processes.