Easily integrate data from any API directly into Google Sheets or Microsoft Excel with a simple setup process.
In today’s data-driven environment, businesses require swift, reliable access to data from diverse sources to drive decision-making and operational efficiency. Recognizing this need, Superjoin is thrilled to introduce Custom API, a flexible connector that integrates any API with your preferred spreadsheet environment.
Step-by-step walkthrough: How to connect APIs to Google Sheets
1
Get Add-ons
Click on Extensions and select Add-ons and choose Get Add-ons. This action will redirect you to the Google Workspace Marketplace.
2
Search Superjoin
In the Google Workspace Marketplace pop-up window, search for Superjoin.
3
Click on Install
Click on the Install button to install Superjoin.
Note: For the best experience, install Superjoin where there’s only a single account logged in the Chrome profile.
4
Launch Superjoin
Once installed, navigate back to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
5
Navigate to Queries
To begin, you can navigate to Queries , choose to Create new query.
6
Connect a New Source
Navigate to Sources, select Connect to a new source and search for Custom API.
7
Choose authorization type
Authorization in API interactions ensures that only authorized users can access specific functions or data. It acts as a gatekeeper, verifying credentials before allowing access to API resources.Superjoin’s CustomAPI supports three distinct types of authorization to cater to different access needs:
Auth type
Description
No Authorization
Ideal for public APIs where no sensitive data is involved. Access is granted without requiring any credentials, simplifying the connection process.
Basic Authorization
Utilizes a username and password to grant access. These credentials are encoded and included in the request header, providing a straightforward method to authenticate users.
Beaer Authorization
Involves a token included in the request header that represents the user’s access permissions. This token is verified by the API server to grant access, offering a token-based approach to handle user sessions and requests.
OAuth2.0 Authorization
Employs an authorization framework that allows third-party applications to access a user’s resources without exposing their credentials. Requires a client ID, client secret, scopes, access token URL, and refresh token URL. Users authenticate with the API provider, which then grants the application an access token. This token is used in subsequent requests to access resources on behalf of the user, ensuring secure and delegated access
Based on the selected authorization type, you’ll be further prompted to enter details.
8
Select request method
The request method determines how data is sent or requested from a server, playing a pivotal role in the interaction with various web services. Superjoin supports two primary HTTP request methods:
Method
Description
GET
Used primarily for retrieving data. This method requests data from a specified resource, and does not usually requires a body, unless specified in the API’s configuration. Most common method for fetching data.
POST
Also used for retrieving data, but when you need to pass on some details along with the request in the form of a body.
9
Enter URL
Specifies the address of your server, basically where your API requests are sent.
Headers play a crucial role in conveying additional information about the request or the response between the client and the server. Some APIs might require or support additional headers that control or modify the operation of the request.In Superjoin’s CustomAPI, headers are formatted as key-value pairs that can be easily added to your API requests.
In the above image we have added a header with key as API_KEY and value as 1kjvwda321wuro.
You cannot add a new header without filling both key and value fields for the previous header.
11
Request Body (payload)
The “body” of a request is crucial when using POST methods, as it contains the data you send to the server. For effective data exchange and customization in API requests through Superjoin’s CustomAPI, understanding how to format and use the body is key.Superjoin supports two flexible ways to add content to the body of your API requests, accommodating various API specifications and user preferences:
Supported types
Description
JSON Editor
This tool allows you to directly input or modify JSON formatted data. The editor provides a clear, structured way to view and edit JSON, ensuring that the data is both valid and precisely structured as the API expects.
Key value pairs
For simpler or flatter data structures, adding body content as key-value pairs is straightforward and intuitive. This approach is user-friendly, especially for those who may not be as familiar with JSON syntax.
JSON Editor
Key value pairs
12
Connect
Click “Connect” to establish the connection with the API. Superjoin will open the Data Preview upon successful creation, allowing you to preview your data.
Step-by-step walkthrough: How to connect APIs to Microsoft Excel
1
Launch Add-ins
Click on Add-ins on the right side of the Excel toolbar.
2
Get Add-in
Click on the searchbar and type “Superjoin”. The results would show our add-in under the More search results section.
3
Authenticate with your Microsoft Account
Once Superjoin launches as a side panel, just click on Sign in with Microsoft and follow the steps to authenticate your Microsoft Office account with Superjoin.
4
Launch Superjoin
You should now see Superjoin running as a side panel on the right side of your screen.
5
Navigate to Queries
To begin, you can navigate to Queries, choose to Create new query.
6
Connect a New Source
Navigate to Sources, select Connect to a new source and search for Custom API.
7
Choose authorization type
Authorization in API interactions ensures that only authorized users can access specific functions or data. It acts as a gatekeeper, verifying credentials before allowing access to API resources.Superjoin’s CustomAPI supports three distinct types of authorization to cater to different access needs:
Auth type
Description
No Authorization
Ideal for public APIs where no sensitive data is involved. Access is granted without requiring any credentials, simplifying the connection process.
Basic Authorization
Utilizes a username and password to grant access. These credentials are encoded and included in the request header, providing a straightforward method to authenticate users.
Beaer Authorization
Involves a token included in the request header that represents the user’s access permissions. This token is verified by the API server to grant access, offering a token-based approach to handle user sessions and requests.
OAuth2.0 Authorization
Employs an authorization framework that allows third-party applications to access a user’s resources without exposing their credentials. Requires a client ID, client secret, scopes, access token URL, and refresh token URL. Users authenticate with the API provider, which then grants the application an access token. This token is used in subsequent requests to access resources on behalf of the user, ensuring secure and delegated access
Based on the selected authorization type, you’ll be further prompted to enter details.
8
Select request method
The request method determines how data is sent or requested from a server, playing a pivotal role in the interaction with various web services. Superjoin supports two primary HTTP request methods:
Method
Description
GET
Used primarily for retrieving data. This method requests data from a specified resource, and does not usually requires a body, unless specified in the API’s configuration. Most common method for fetching data.
POST
Also used for retrieving data, but when you need to pass on some details along with the request in the form of a body.
9
Enter URL
Specifies the address of your server, basically where your API requests are sent.
Headers play a crucial role in conveying additional information about the request or the response between the client and the server. Some APIs might require or support additional headers that control or modify the operation of the request.In Superjoin’s CustomAPI, headers are formatted as key-value pairs that can be easily added to your API requests.
In the above image we have added a header with key as API_KEY and value as 1kjvwda321wuro.
You cannot add a new header without filling both key and value fields for the previous header.
11
Request Body (payload)
The “body” of a request is crucial when using POST methods, as it contains the data you send to the server. For effective data exchange and customization in API requests through Superjoin’s CustomAPI, understanding how to format and use the body is key.Superjoin supports two flexible ways to add content to the body of your API requests, accommodating various API specifications and user preferences:
Supported types
Description
JSON Editor
This tool allows you to directly input or modify JSON formatted data. The editor provides a clear, structured way to view and edit JSON, ensuring that the data is both valid and precisely structured as the API expects.
Key value pairs
For simpler or flatter data structures, adding body content as key-value pairs is straightforward and intuitive. This approach is user-friendly, especially for those who may not be as familiar with JSON syntax.
JSON Editor
Key value pairs
12
Connect
Click “Connect” to establish the connection with the API. Superjoin will open the Data Preview upon successful creation, allowing you to preview your data.
