SheetLink

Gmail_SendEmail

=Gmail_SendEmail ("from","to","subject","message","options")

Gmail_CreateDraft

=Gmail_CreateDraft ("from","to","subject","message","options")

"options"

available in every formula 💪

Overwrite Request Defaults

Find My Gmail API Key

Authorization granted by clicking link!

"key=(APP-API-KEY, reset, or ?)"

Set, reset, or query your API key for a tool

"{PAYLOAD-HERE}"

JSON payload to send with the request

"{<encode>PAYLOAD-HERE</encode>}"

base64 encode text in the payload request

"<curl>CURL-HERE</curl>"

Return response from cURL formated request

JSON headers to send with the request

"headers={HEADERS-HERE}"

set response contentType (if not applicaiton/json)

"contentType=CONTENT-TYPE-HERE"

KEY:VALUE parameter pairs to send with the request

"KEY=VALUE"

Full request url (or path only for this =TOOL formula)

"https://BASE-URL/URL-PATH" OR "/URL-PATH"

Set method (default: GET without payload, POST with payload)

"method=METHOD-HERE"

Overwrite Response Defaults

"rawHeaders"

Returns raw response /QUERY headers

"/QUERY"

rawHeaders to query

"noHeaders"

Removes all headers from the response

Inherit values from JSON parent elements

"inheritParents"

Truncate (shorten) long JSON response values

"truncateValues"

Prepend each value with the row & column it belongs in

"debugLocation"

Return raw JSON response (with */QUERY and $QUERY)

"*" (advanced option)

Raw header(s) to query (raw JSON response)

"*/QUERY" (advanced option)

Return response along with request options

"*?" (advanced option)

"$QUERY" (advanced option)

JSON Path-Plus Query

available in every formula 💪

Video Tutorials

Get started

Data structure setup & CMS

Implementation in Webflow

Next steps