SheetLink
Search…
πŸ’ͺ
"options"
Control the request to and response from any application.
All "options" must be a cell reference (B2), a cell range (B2:D2), or comma separated in double quotes ("option1","option2")

Example 1 (simple)

=HubSpot_getContacts("rawHeaders,name=Elon,/name")

API Request "options"

The below "options" are sent along with the request to your application.
"options"
API Key (set, reset or query)
"key=reset" (reset API key)
"key=?" (query API key)
** "key=MY-KEY" (**careful, key is saved to sheet history)
The alternative "πŸ” Authentication" method is recommended
Payload (JSON format)
"{'KEY':'VALUE'}"
"{'pie':{'cook_time':'20 Min','temp_degrees':'350'}}"
Payload (base64 encode)
"{'KEY':'<encode>VALUE</encode>'}"
cURL (or =cURL formula)
"<curl>cURL-HERE</curl>"
Headers (JSON format)
"headers={'KEY':'VALUE'}"
"headers={'Accept-Version':'1.0'}"
Content Type
"contentType=application/x-www-form-urlencoded"
"contentType=application/json" (default if blank)
URL Parameters
"KEY=VALUE"
"color=blue,[email protected]"
Method
"method=METHOD-HERE"
"method=GET" (default if no Payload)
"method=POST" (default if Payload)

API Response "options"

The below "options" are used to format the app's JSON API response.
"options"
Response Headers
"rawHeaders" (returns raw /QUERY headers)
"/QUERY" ("rawHeaders" to query)
"noHeaders" (return data without headers)
Response Data
"inheritParents" (inherit JSON parent elements)
"truncateValues" (shorten response values)
"debugLocation" (row & column with values)
Raw Response Data (advanced)
"*" (return raw JSON response)
"*/QUERY" (query raw JSON response)
"*?" (request options with response)
"$QUERY" (JSON Path-Plus query)
You can try the SheetLink pre-built app formulas, or our =API("options") to interact with any application API.

Navigation

Page
πŸš€ Quick Start​
60 second getting started guide.
​❓ FAQ​
Answers to frequently asked SheetLink questions.
πŸ”— Apps​
Explore the apps we've already built formulas for.
πŸ› οΈ Functions​
Powerful functions unique to SheetLink.

πŸš‘ Need Help?

You can always contact us via [email protected] or by messaging us on Twitter @SheetLink​
Last modified 2mo ago