The data in many eCommerce and marketing platforms such as Salesforce and MySQL databases can be accessed via their own API. Others may require additional information such as database name, username, password, and such.
As the data in these platforms can only be accessed by authorized users, accessing the data through the API of these platforms requires API keys.
The data that can be accessed via a platform’s API is usually in JSON format. We can process it by using the ImportJSON code below:
After copying the code, go back to Google Sheets. Click Extensions then select Apps Script.
A new tab will load for Google Apps Script with a code area.
Clear the code area then paste the code in it.
Save the script by clicking Save project.
Go back to the tab where Google Sheets is loaded. To use the script to import data to Google Sheets via API, use the following formula:
=ImportJSONBasicAuth("database_URL","api_key","password")
Where:
database_URL has the following format: https://{hostname}/admin/api/{version}/{resource}.json
Api_key is the API key to access the data
And Password is the password to access the data.
Add it to the cell where you want to insert the data.
Pretty straightforward? Well it depends. Not all platforms work the same way! But we got you covered. Here is an alternative: Lido.app. Yep, this website you are browsing right now has its own spreadsheet. It has a built-in import data function that can help you integrate data from different platforms in just a few clicks. Scroll right to the next section to see how Lido.app works!
It will be much better if a spreadsheet has built-in import functions from different eCommerce and marketing platforms. Fortunately you don’t have to look far! We present to you Lido.app. How easy is it to use? Here are the steps:
Click the Connect Data button on the upper-left corner of Lido sheet.
A box labeled Add Data will appear, listing the platforms you can integrate with Lido. Select the platform you want to integrate.
The information needed to connect the platform to Lido depends on the platforms themselves, so make sure you prepare them in advance. They usually include one or more of the following:
After selecting the platform, you will be asked to input such information. Add them, then click Connect with Platform.
A new tab will load, where you authorize Lido to access the data in the platform you selected. Approve the request.
You will be returned to the Lido tab, showing the connection success.
You then select the data to import next. Lido automatically detects the data in the platform you connected. First, select the object and the table to import. Next, select the specific columns to import.
Once done, click Add Data. The data is now imported to Lido.app!
Having seen how to import data to Google Sheets via API, do you still want to use it as your main spreadsheet platform? Or do you want to try something new, something that allows you to easily import data from different platforms in just a few clicks?
