Hello! Excited to share a step-by-step guide on how to join your MySQL and Google Sheets data with a Lido spreadsheet.
Context for this tutorial: We are trying to solve a specific data silo issue - we have some accounts data in Google Sheets (e.g., Account Contact, Account ID, Account Value, Contract length, and Days Since Last Interaction). We also have some accounts data in MySQL (e.g., id, and Account Name).
We wish to easily join tables from both data sources to view a single record of each account (including all data from Google Sheets and MySQL), and specifically we'd like to match Account Names to the correct Account Contact, Account Value, Contract Length, and Days Since Last Interaction. Lido will help me accomplish this.
Lido is a spreadsheet with superpowers that can connect directly to your data (Hubspot, Salesforce, databases, Zendesk, MySQL, Google Sheets and more). You can work with it just like a normal Google Sheet or Excel document. No more importing CSV’s.
If you want to take it further, you can build no-code tools and dashboards powered by spreadsheet formulas (i.e., no more annoying and painful software coding needed). If you can organize your data in a spreadsheet, you can build an internal tool to power customer support, operations, growth, and other internal teams.
Connect to Google Sheets data 'live' via your Lido spreadsheet following the listed steps below:
You now have created a file and connected 'live' to you Google Sheets data. Now you want to also connect to your MySQL data.
Connect to MySQL data 'live' via your Lido spreadsheet following the listed steps below:
The next step is to join the Google Sheets and MySQL tables on the common “id” field to get a single record / view for an account that includes data from both Google Sheets and MySQL.
Using Lido, you have now created a single view of account data across your data silos (i.e., Google Sheets and MySQL). No painful software coding neccessary - just a few clicks of the mouse!