HTTP & Integrations

Lido provides formulas for making HTTP requests and interacting with databases directly from your spreadsheet.

---

CALLURL

Makes an HTTP request to an external URL. This is an action formula — it executes when triggered.

Syntax:

=CALLURL(url, method)
=CALLURL(url, method, body, headers, output_ref)

Parameters:

Parameter	Description	Required
url	The URL to call	Yes
method	HTTP method ("GET", "POST", etc.)	Yes
body	Request body	No
headers	Request headers (JSON string)	No
output_ref	Cell reference to write the response	No

---

FETCH

Makes an HTTP request and returns the response directly. Unlike CALLURL, FETCH is not an action — it executes immediately during formula evaluation.

Syntax:

=FETCH(url, method)
=FETCH(url, method, body, headers)

Parameters:

Parameter	Description	Required
url	The URL to call	Yes
method	HTTP method ("GET", "POST", etc.)	Yes
body	Request body	No
headers	Request headers (JSON string)	No

Example:

=FETCH("https://api.example.com/data", "GET")

Returns the response body as a string. Use with JQ to parse JSON responses:

=JQ(FETCH("https://api.example.com/users", "GET"), ".users[0].name")

---

SQLQUERY

Executes a SQL read query (SELECT) against a connected database. This is not an action — it executes immediately during formula evaluation and returns the result.

Syntax:

=SQLQUERY(credential, sql_query)
=SQLQUERY(credential, sql_query, ssl)

Parameters:

Parameter	Description	Required
credential	Database credential ID	Yes
sql_query	SQL query to execute	Yes
ssl	Whether to use SSL	No

---

SQLMUTATION

Executes a SQL write query (INSERT, UPDATE, DELETE) against a connected database. This is an action formula — it executes when triggered.

Syntax:

=SQLMUTATION(credential, sql_query)
=SQLMUTATION(credential, sql_query, ssl)

Parameters:

Parameter	Description	Required
credential	Database credential ID	Yes
sql_query	SQL query to execute	Yes
ssl	Whether to use SSL	No

---

HubSpot

UPDATEHUBSPOT

Updates a record in HubSpot.

Syntax:

=UPDATEHUBSPOT(object_type, object_id, property_updates)

Parameters:

Parameter	Description	Required
object_type	HubSpot object type (e.g., "contacts", "deals")	Yes
object_id	ID of the record to update	Yes
property_updates	Properties to update (JSON)	Yes

---

ADDHUBSPOT

Creates a new record in HubSpot.

Syntax:

=ADDHUBSPOT(object_type, properties)

Parameters:

Parameter	Description	Required
object_type	HubSpot object type	Yes
properties	Properties for the new record (JSON)	Yes

---

DELETEHUBSPOT

Deletes a record from HubSpot.

Syntax:

=DELETEHUBSPOT(object_type, object_id)

Parameters:

Parameter	Description	Required
object_type	HubSpot object type	Yes
object_id	ID of the record to delete	Yes