SpreadsheetWeb Hub

With SpreadsheetWeb Hub modules in Make, you can receive the calculated values, manage the records, download files, and update applications in your SpreadsheetWeb Hub account.

To use the SpreadsheetWeb Hub modules, you must have a SpreadsheetWeb Hub account You can create an account at hub.spreadsheetweb.com.

Refer to the SpreadsheetWeb Hub API documentation for a list of available endpoints.

Connect SpreadsheetWeb Hub to Make

To establish the connection, you must:

Log in to your Make account, add a SpreadsheetWeb Hub module to your scenario, and click Create a connection.
Optional: In the Connection name field, enter a name for the connection.
Click Save.
If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your scenario and add more SpreadsheetWeb Hub modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

Build SpreadsheetWeb Hub Scenarios

After connecting the app, you can perform the following actions:

Calculation

Get a Calculated Value

Returns a calculated value from your app in SpreadsheetWeb Hub.

Connection	Establish a connection to your SpreadsheetWeb Hub account.
Workspace	Select the workspace where your app is located.
Application	Select the application you want to perform calculations on.
Output Named Ranges	Enter the values you want to send as inputs to your application.

Data Record

Watch New Data Record

Triggers when a new data record has been added to an application.

Connection	Establish a connection to your SpreadsheetWeb Hub account.
Workspace	Select the workspace where your app is located.
Application	Select the application you want to watch the new data records on.
Database Columns	Select the columns you want to retrieve values.
Limit	Enter the maximum number of results to be worked with during one execution cycle.

Create or Update Data Record

Creates a new data record or updates an existing one with specified record id.

Connection	Establish a connection to your SpreadsheetWeb Hub account.
Existing Record id	Enter (map) the record ID to update an existing record, or leave it blank to create a new record.
Load Existing Data?	Enter (map) whether to preload existing data for updates or start with a fresh set of inputs.
Workspace	Select the workspace where your app is located.
Application	Select the application where you want to create or update data records.

Other

Make an API Call

Performs an arbitrary authorized API call.

Connection	Establish a connection to your SpreadsheetWeb Hub account.
URL	Enter a path relative to https://api.spreadsheetweb.com/. For the list of available endpoints, refer to the SpreadsheetWeb Hub API Documentation.
Method	Select the HTTP method you want to use: GET - to retrieve information for an entry. POST - to create a new entry. PUT - to update/replace an existing entry. PATCH - to make a partial entry update. DELETE - to delete an entry.
Headers	Enter the desired request headers. You don't have to add authorization headers; we already did that for you.
Query String	Enter the request query string.
Body	Enter the body content for your API call.

Example of Use

The following API call retrieves a filtered list of named ranges from an application:

URL:

/designer/namedrange/getnamedrangesoftype

Method:

POST

The result can be found in the module's Output under Bundle > Body.

Get File

Downloads saved file attachment or document.

Connection	Establish a connection to your SpreadsheetWeb Hub account.
Workspace	Select the workspace where your app is located.
Existing Record ID	Submit the record id to update an existing record or leave it blank to create a new record.
Application	Select the application from which you want to download the saved file or document.

Update an Application

Updates an existing SpreadsheetWeb Hub application's file.

Connection	Establish a connection to your SpreadsheetWeb Hub account.
Request Type	Select the type of request you want to perform: GetStatus Start Update Publish
Workspace	Select the workspace where your app is located.
Application	Select the application from which you want to download the saved file or document.
File Name	Enter (map) the name of the file you want to update.
File	Enter (map) the file itself.

Download File From URL

Takes URLs from Get a Calculated Value module and gives files.

Connection	Establish a connection to your SpreadsheetWeb Hub account.
File URL	Enter (map) the file URL that you want to download the file from.
File Name	Enter (map) the name of the file.

In this section: