# Welcome Easily link your apps with Google Sheets using the SheetLink add-on 🎉 We built [SheetLink](https://Sheet.Link) to enable non-coders to interact with their apps using easy formulas in Google Sheets. {% hint style="success" %} Prefer learning by watching? Skip to [to the quick start tutorial](/#video-tutorial) {% endhint %} ### Where to? | 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.

| |

💪 "options"

Control the request to and response from any application.

| #### Video Tutorial {% embed url="" %} ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Quickstart 60 second getting started guide {% hint style="success" %} Prefer video tutorials? Skip [here](/quickstart#video-tutorial) {% endhint %} ### **Step 1** **Create a new** [**Google Sheet**](https://sheets.google.com) **✅** ### **Step 2** **Find & install the** [**SheetLink add-on**](https://workspace.google.com/marketplace/app/sheetlink_api_app_formulas/308627233175) **🔎** ![](/files/-MjtkN4MRzLPcL0E9fUy) ### **Step 3** **You are ready to try your first** [**App formula**](/formulas/apps) **🎉** *You can start by getting live weather from any major city using this MetaWeather formula in your Google Sheet!* ``` =MetaWeather_Location("New York") ``` ![](/files/-MjuHA5xnUHKt23S8DtZ) {% hint style="info" %} The MetaWeather App does not require an API key. Check out the **key=** ["options"](/formulas/options) for apps that do require authentication. {% endhint %} #### Video Tutorial {% embed url="" %} ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🔗 Apps

Explore the apps we've already built formulas for.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # FAQ Answers to frequently asked SheetLink questions. ### What can the SheetLink add-on do? The SheetLink add-on enables you to interact with any API from Google Sheets. Sending an email, listing members, or updating a website are just some of the SheetLink formula capabilities. ### What does SheetLink cost? 500 Tasks (successful API requests) per month are free with your account! Please review the [SheetLink pricing page](https://www.sheet.link/#pricing) for our latest power-user pricing. ### What if I don't see my App listed? Thankfully the SheetLink [=API](/formulas/functions) formula allows you to interact with any API that returns data in JSON format using only ["options"](/formulas/options). Please [contact us](/faq#need-help) if you need any assistance! {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} ## Errors SheetLink is still in beta testing, so errors may occur. #### "Loading..." If this error continues after refreshing the formula, please [contact us](/faq#need-help) for assistance and we will do our best to help! #### "#NAME" This indicates that the formula you attempted to use is not recognized. Ensure you have installed SheetLink in accordance with the [Quickstart](/quickstart) and have typed the [app formula](/formulas/apps) properly. #### Another error? Please [contact us](/faq#need-help) for assistance and we will do our best to help! ### Navigation | Page | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

🚀 Quick Start

60 second getting started guide.

| |

🔗 Apps

Explore the apps we've already built formulas for.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Security Use SheetLink while keeping your data safe. ## **Google Sheets Access** Google has made it [easy to control who has access](https://support.google.com/docs/answer/2494822) to your current sheet. Keep in mind, SheetLink only works in sheets with the add-on installed and activated. ## API Keys & Authentication From your google sheet, select **"Add-ons" > "SheetLink" > "🔐 Authentication"** for all apps requiring authentication. All API and authentication keys are securely saved as [Google Document Properties](https://developers.google.com/apps-script/guides/properties) of the current Google Sheet only and **are never accessible by the SheetLink team**. App API keys can be used with respective SheetLink app formulas by anyone with access to the Google Sheet. {% hint style="success" %} The **"key=reset"** [option](/formulas/options) will reset the authentication for any app {% endhint %} # Apps Explore the apps we've already built formulas for. ### 🔍 for or select an application | App | | -------------------------------------------------------------------------------------------------------------------------- | |

Quick Start

60 second getting started guide

| |

Apps

Explore apps we've already built formulas for

| |

Functions

Powerful functions unique to SheetLink

| ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Webflow Interact with your Webflow CMS Collections to view, add, update, and delete items easily with SheetLink formulas in Google Sheets. {% hint style="success" %} Review our [Webflow template](https://docs.google.com/spreadsheets/d/1VbKOgxuh11ODxiMOcG3Fv27AzPqKqQUzE2oXo7bvdfA/edit?usp=sharing) and watch to the [Webflow video tutorial](https://youtu.be/wSNSeKAHzGU) (4 Minutes) {% endhint %} | Formula | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

Interact with Webflow API using only the SheetLink "options"

=Webflow( "options")

| | **=Webflow\_UpdateLiveCollectionItem( "collection\_id" ,"item\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_UpdateCollectionItem( "collection\_id" ,"item\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_PatchLiveCollectionItem( "collection\_id" ,"item\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_PatchCollectionItem( "collection\_id" ,"item\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_GetCollectionItem( "collection\_id" ,"item\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_DeleteCollectionItem( "collection\_id" ,"item\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_CreateCollectionItem( "collection\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_CreateLiveCollectionItem( "collection\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_GetCollectionFullSchema( "collection\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_GetCollectionItems( "collection\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_CreateCollectionItem( "collection\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_GetCollections( "site\_id" ,**[**"options"**](/formulas/options)**)** | | **=Webflow\_GetSites(**[**"options"**](/formulas/options)**)** | Developers can review the official [Webflow API Documentation](https://developers.Webflow.com) 📖 {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} ### Video Tutorial {% embed url="" %} ### Template [Webflow Google Sheets Template](https://docs.google.com/spreadsheets/d/1VbKOgxuh11ODxiMOcG3Fv27AzPqKqQUzE2oXo7bvdfA/edit?usp=sharing) ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # HubSpot The HubSpot APIs are designed to enable teams of any shape or size to interact with their HubSpot data. Review the official [HubSpot API Documentation](https://developers.hubspot.com/docs/api/overview) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=HubSpot( "options")

Interact with the HubSpot API using only the SheetLink "options"

| |

=HubSpot\_GetContacts( "options")

List your HubSpot contacts

| {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # OpenAI The OpenAI API can be applied to virtually any task that involves understanding or generating natural language or code. GPT3 is one of OpenAI's most popular AI models. {% hint style="success" %} Copy our [OpenAI GPT3 Template](https://docs.google.com/spreadsheets/d/1G5RqU8qOh4Ww1Qf-yL6LddTYUfpRiUCtzoFclPQD3YY/edit?usp=sharing) {% endhint %} Review the official [OpenAI API Documentation](https://developers.hubspot.com/docs/api/overview) 📖 | Formula (No OpenAI Key Required 🎉) | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=OpenAI\_GPT3\_SummarizeForASecondGrader( "text\_to\_summarize", "options")

Summarize text (600 character max) for a second grader using the Davinci engine

| | Formula (OpenAI API Key Required) | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=OpenAI( "options")

Interact with the OpenAI API using only the SheetLink "options"

| |

=OpenAI\_GPT3CompletionDavinci( "prompt", "max\_tokens", "options")

Get a GPT3 completion using the Davinci engine

| |

=OpenAI\_GPT3Completion( "prompt", "max\_tokens", "engine", "options")

Get a GPT3 completion

| {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Memberstack Review the official [Memberstack API Documentation](https://developers.hubspot.com/docs/api/overview) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

=Memberstack( "options")

Interact with the Memberstack API using only the SheetLink "options"

| |

=Memberstack\_GetMembers( "options")

Get a list of your Memberstack members

| |

=Memberstack\_UpdateMembership( "member\_id", "membership\_id", "options")

Update the current membership of a Memberstack member (updating to a paid plan requires a default payment method)

| |

=Memberstack\_GetMemberships( "options")

Get a list of your site's current Memberstack memberships

| |

=Memberstack\_GetWebsite( "options")

Get details about your current Memberstack website

| {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} #### Video Tutorial {% embed url="" %} ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Slack Review the official [Slack API Documentation](https://api.Slack.com/methods) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=Slack( "options")

Interact with the Slack API using only the SheetLink "options"

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Twitter Review the official [Twitter API Documentation](https://developer.twitter.com/en/docs/twitter-api) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=Twitter( "options")

Interact with the Twitter API using only the SheetLink "options"

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Gmail Review the official [Gmail API Documentation](https://developers.google.com/gmail/api/reference/rest) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=Gmail( "options")

Interact with the Gmail API using only the SheetLink "options"

| |

=Gmail\_SendEmail( "from", "to", "subject", "message", "options")

Send an email using Gmail

| |

=Gmail\_CreateDraft( "from", "to", "subject", "message", "options")

Create a draft in Gmail

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Respond.io The Respond.io API allows you to add, edit and retrieve contact information. Review the official[ Respond API Documentation](https://docs.respond.io/developer-api) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=Respond( "options")

Interact with the Respond API using only the SheetLink "options"

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Airtable Use the Airtable API to create, read, update, and destroy records in your Airtable Base. Review the official[ Airtable API Documentation](https://airtable.com/api) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=Airtable( "options")

Interact with the Airtable API using only the SheetLink "options"

| |

=Airtable\_GetAll("base\_id" ,"table\_name" ,"options")

Retrieve all existing records in a defined table.

| |

=Airtable\_Get( "base\_id" ,"table\_name", "record\_id" ,"options")

Retrieve an existing record in a defined table.

| |

=Airtable\_Delete( "base\_id" ,"table\_name", "record\_id" ,"options")

Delete an existing record in a defined table.

| |

=Airtable\_Update( "base\_id" ,"table\_name", "record" ,"options")

Update an existing record in a defined table. ("record" must be in JSON format and include the record\_id of the record to update)

| |

=Airtable\_Create( "base\_id" ,"table\_name", "record" ,"options")

Create a new record in a defined table. ("record" must be in JSON format)

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # bit.io The fastest way to get a database Review the official[ bit.io API Documentation](https://airtable.com/api) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=bitio( "options")

Interact with the bit.io API using only the SheetLink "options"

| |

=bitio\_GetRepos( "options")

Get all bit.io repos

| |

=bitio\_GetRepo( "repo\_name", "options")

Get a single bit.io repos

| |

=bitio\_SQLQuery( "SQL\_query", "options")

Make a bit.io SQL query

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # MetaWeather MetaWeather provides an API that delivers JSON over HTTPS for access to live weather data. Review the official[ MetaWeather API Documentation](https://www.metaweather.com/api/) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

=MetaWeather( "options")

Interact with the MetaWeather API using only the SheetLink "options"

| |

=MetaWeather\_LocationQuery( "location", "options")

Query the data for any major city

| |

=MetaWeather\_Location( "location", "options")

Get the weather data for any major city

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # CoinMarketCap Showcasing the crypto revolution to +270M monthly visitors! Review the official [CoinMarketCap Documentation](https://coinmarketcap.com/api/documentation/v1/) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=CoinMarketCap( "options")

Interact with the CoinMarketCap API using only the SheetLink "options"

| |

=CoinMarketCap\_QuotesLatest( "options")

Returns the latest market quote for 1 or more cryptocurrencies.

| |

=CoinMarketCap\_QuotesLatestQuerySymbol( "symbol", "options")

Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency symbol such as "BTC".

| |

=CoinMarketCap\_QuotesLatestQuerySlug( "slug", "options")

Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency slug such as "bitcoin".

| |

=CoinMarketCap\_QuotesLatestQueryId( "id", "options")

Returns the latest market quote for 1 or more cryptocurrencies by querying a CoinMarketCap id such as "1".

| |

=CoinMarketCap\_MarketPairsLatest( "options")

Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency.

| |

=CoinMarketCap\_MarketPairsLatestQuerySymbol( "symbol", "options")

Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency symbol.

| |

=CoinMarketCap\_MarketPairsLatestQuerySlug( "slug", "options")

Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency slug.

| |

=CoinMarketCap\_MarketPairsLatestQueryId( "id", "options")

Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency id.

| |

=CoinMarketCap\_Airdrops( "options")

Returns a list of past, present, or future airdrops which have run on CoinMarketCap.

| |

=CoinMarketCap\_Airdrop( "id", "options")

Returns information about a single airdrop available on CoinMarketCap. Includes the cryptocurrency metadata.

| |

=CoinMarketCap\_TrendingGainersLosers( "options")

Returns a paginated list of all trending cryptocurrencies, determined and sorted by the largest price gains or losses.

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Bannerbear A service that auto generates images and videos. {% hint style="success" %} Review our [Bannerbear template](https://docs.google.com/spreadsheets/d/1623-oKHstsUsRY1CafRaxIKQrAkUt39cF3sVuDD1CeQ/edit?usp=sharing) and watch to the [Bannerbear video tutorial](https://www.loom.com/share/3f6a14b049864ff189cc7b517242de83) {% endhint %} | Formula | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=Bannerbear( "options")

Interact with the Bannerbear API using only the SheetLink "options"

| |

=Bannerbear\_GetTemplates( "options")

Lists templates inside a project.

| |

=Bannerbear\_CreateImage( "template" ,"modifications" ,"options")

Initiate the creation of a Bannerbear image. See Bannerbear modification examples here.

| |

=Bannerbear\_GetImages( "options")

Lists images inside a project.

| |

=Bannerbear\_GetImage( "image\_uid", "options")

Retrieves a single Image object referenced by its unique ID.

| |

=Bannerbear\_GetImagePNG( "image\_uid", "options")

Get a PNG URL of a single Image referenced by its unique ID.

| |

=Bannerbear\_GetImageJPG( "image\_uid", "options")

Get a JPG URL of a single Image referenced by its unique ID.

| Developers can review the official [Bannerbear API Documentation](https://developers.bannerbear.com/) 📖 {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} ### Video Tutorial {% embed url="" %} ### Template [Bannerbear Google Sheets Template](https://docs.google.com/spreadsheets/d/1623-oKHstsUsRY1CafRaxIKQrAkUt39cF3sVuDD1CeQ/edit?usp=sharing) ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # NFTPort The Stripe for NFTs: One-Stop & Simple NFT Infrastructure & APIs for Developers {% hint style="success" %} Copy our [NFTPort Google Sheets Template](https://docs.google.com/spreadsheets/d/1bS1C95HBF6wUABYpc9gAbiRp2DY5jKY-hLwSvqOfTh4/edit?usp=sharing) and watch to the [NFTPort Video Tutorial](#video-tutorial) {% endhint %} | Formula | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=NFTPort( "options")

Interact with the NFT Port API using only the SheetLink "options"

| |

=NFTPort\_GetNFTs( "search\_text" ,"options")

Searches NFTs across multiple chains using a text query, specifically the name and description fields from the metadata.

| |

=NFTPort\_GetNFTsQueryPage( "search\_text" ,"page\_number" ,"options")

Default value: 1

| |

=NFTPort\_GetNFT( "transaction\_hash" ,"chain", "option)

Returns the details of a minted NFT. You need to provide transaction\_hash

| |

=NFTPort\_MintNFT( "chain" ,"contract\_address", "metadata\_uri" ,"mint\_to\_address" ,"options")

Mints an NFT to your previously deployed contract (i.e. collection). This minting consists of multiple steps and enables you to customize the whole minting flow for your exact needs.

First, you can create your contract\_address using =NFTPort\_DeployNFTContract
Secondly, you can create your metadata\_uri using =NFTPort\_IFPS\_UploadMetadata

After minting, the NFT will appear in the mint\_to\_address wallet.

polygon & rinkeby chains only are supported by NFTPort for now

| |

=NFTPort\_MintNFTSetId( "chain" ,"contract\_address", "metadata\_uri" ,"mint\_to\_address", "token\_id" ,"options")

Same as =NFTPort\_MintNFT, yet the NFT ID can be set easily

| |

=NFTPort\_UpdateNFT( "chain" ,"contract\_address", "metadata\_uri" ,"token\_id" ,"options")

Updates an NFT which has been previously minted with one of the =NFTPort\_MintNFT formulas using a contract with metadata\_updateable set to true

| |

=NFTPort\_DeployNFTContract( "chain" ,"name", "symbol" ,"options")

Deploys a standard ERC-721 smart contract where your can mint your NFTs. This is a required step if you wish to use =NFTPort\_MintNFT formulas as the contract will represent your own collection.

| |

=NFTPort\_DeployNFTContractSetOwner( "chain" ,"name", "symbol" ,"owner\_address" ,"options")

Same as =NFTPort\_DeployNFTContract, yet the owner address can be set easily.

| |

=NFTPort\_DeployNFTContractDynamicSetOwner( "chain" ,"name", "symbol" ,"owner\_address" ,"options")

Same as =NFTPort\_DeployNFTContractSetOwner, yet metadata\_updateable is set to true by default to enable dynamic NFT's using the formula.

| |

=NFTPort\_IFPS\_UploadMetadata( "chain" ,"name", "symbol" ,"owner\_address" ,"options")

Uploads a file to IPFS which makes your NFT storage easy. You can use the returned ipfs\_url

| Developers can review the official [NFT Port API Documentation](https://docs.nftport.xyz/docs/nftport) 📖 {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} ### Video Tutorial {% embed url="" %} ### Template (Copy & Customize) [NFTPort Google Sheets Template](https://docs.google.com/spreadsheets/d/1bS1C95HBF6wUABYpc9gAbiRp2DY5jKY-hLwSvqOfTh4/edit?usp=sharing) ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # OpenSea The world's first and largest NFT marketplace {% hint style="success" %} OpenSea Google Sheets template and tutorial video coming soon! {% endhint %} | Formulas | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=OpenSea( "options")

Interact with the OpenSea API using only the SheetLink "options"

| | **=OpenSea\_GetAssets** | | **=OpenSea\_GetAssetsQueryOwner** | | **=OpenSea\_GetAssetsQueryTokensContracts** | | **=OpenSea\_GetBundles** | | **=OpenSea\_GetAsset** | | **=OpenSea\_GetContract** | | **=OpenSea\_GetEvents** | | **=OpenSea\_GetCollections** | | **=OpenSea\_GetCollectionsQueryOwner** | | **=OpenSea\_GetCollectionsQueryOwnerOffset** | | **=OpenSea\_GetOrders** | | **=OpenSea\_GetOrdersQueryOwner** | | **=OpenSea\_GetOrdersQueryContract** | Developers can review the official[ OpenSea API Documentation](https://docs.opensea.io/reference/api-overview) 📖 {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Stripe Stripe is a suite of payment APIs that powers commerce for online businesses of all sizes. Review the official [Stripe API Documentation](https://Stripe.com/docs/api) 📖 {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} | Formula | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

=Stripe( "options")

Interact with the Stripe API using only the SheetLink "options"

| |

=Stripe\_CreateCustomer( "options")

Create a Stripe customer

| |

=Stripe\_UpdateCustomer( "contact\_id", "options")

Update a Stripe customer

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Moralis The Web3 Operating System: Build & scale their dApps without the cost & complexity. {% hint style="success" %} Moralis Google Sheets template and tutorial video coming soon! {% endhint %} | Formulas | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=Moralis( "options")

Interact with the Moralis API using only the SheetLink "options"

| |

=Moralis\_GetBlock( "chain", "block\_number\_or\_hash", "options")
Gets the contents of a block by block hash

| |

=Moralis\_GetBlockDate( "chain", "date", "options")
Gets the closest block of the provided date

| |

=Moralis\_GetAddressLogs( "chain", "address", "options")
Gets the logs from an address

| |

=Moralis\_GetHashTransactions( "chain", "transaction\_hash", "options")
Gets NFT transfers by block number or block hash

| |

=Moralis\_GetBlockNFTTransactions( "chain", "block\_number\_or\_hash", "options")
Gets the contents of a block transaction by hash

| |

=Moralis\_GetAddressNFTsFormatDecimal( "chain", "address", "options")
Gets native transactions in descending order based on block number

| |

=Moralis\_GetAddressTransactions( "chain", "address", "options")
Gets native balance for a specific address

| |

=Moralis\_GetAddressNativeBalance( "chain", "address", "options")
Gets token balances for a specific address

| |

=Moralis\_GetAddressTokenBalance( "chain", "address", "options")
Gets ERC20 token transactions in descending order based on block number

| |

=Moralis\_GetAddressTokenTransactions( "chain", "address", "options")
Gets NFTs owned by the given address

| |

=Moralis\_GetAddressNFTTransactions( "chain", "address", "options")
Gets the transfers of the tokens matching the given parameters

| |

=Moralis\_GetTokenMetadata( "chain", "token\_address", "options")
Returns metadata (name, symbol, decimals, logo) for a given token contract address.

| |

=Moralis\_GetTokenSymbolMetadata( "chain", "symbol", "options")
Returns metadata (name, symbol, decimals, logo) for a given symbol

| |

=Moralis\_GetTokenAddressPrice( "chain", "token\_address", "options")
Returns the price nominated in the native token and usd for a given token contract address.

| |

=Moralis\_GetTokenAddressTransactions( "chain", "token\_address", "options")
Gets ERC20 token contract transactions in descending order based on block number

| |

=Moralis\_GetTokenAddressAllowance( "chain", "token\_address", "owner\_address", "spender\_address", "options")
Gets the amount which the spender is allowed to withdraw from the spender

| |

=Moralis\_GetNFTSearch( "chain", "query", "options")
Gets NFTs that match a given metadata search.

| |

=Moralis\_GetContractNFTs( "chain", "contract\_address", "options")
Gets data, including metadata (where available), for all token ids for the given contract address.

| |

=Moralis\_GetContractNFTTransfers( "chain", "contract\_address", "options")
Gets the transfers of the tokens matching the given parameters

| |

=Moralis\_GetContractNFTOwners( "chain", "contract\_address", "options")
Gets all owners of NFT items within a given contract collection

| |

=Moralis\_GetContractNFTMetadata( "chain", "contract\_address", "options")
Gets the contract level metadata (name, symbol, base token uri) for the given contract

| |

=Moralis\_GetContractNFTToken( "chain", "contract\_address", "token\_id", "options")
Gets data, including metadata (where available), for the given token id of the given contract address.

| |

=Moralis\_GetContractNFTTokenOwners( "chain", "contract\_address", "token\_id", "options")
Gets all owners of NFT items within a given contract collection

| |

=Moralis\_GetContractNFTTokenTransfers( "chain", "contract\_address", "token\_id", "options")
Gets the transfers of the tokens matching the given parameters

| |

=Moralis\_GetDomainResolved( "currency", "domain", "options")
Resolves an Unstoppable domain and returns the address

| |

=Moralis\_GetLiquidityReserves( "chain", "pair\_address", "options")
Get the liquidity reserves for a given pair address

| |

=Moralis\_GetPairAddress( "chain", "exchange", "token0\_address", "token1\_address", "options")
Fetches and returns pair data of the provided token0+token1 combination. The token0 and token1 options are interchangable (ie. there is no different outcome in "token0=WETH and token1=USDT" or "token0=USDT and token1=WETH")

| Developers can review the official[ Moralis Documentation](https://docs.moralis.io/moralis-server/web3-sdk/moralis-web3-api-rest) 📖 {% hint style="success" %} Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡 {% endhint %} {% hint style="info" %} Note that ["options"](/formulas/options) are optional, other variables are required 👍 {% endhint %} ### Navigation | Page | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |

🚀 Quick Start

60 second getting started guide.

| |

❓ FAQ

Answers to frequently asked SheetLink questions.

| |

🛠️ Functions

Powerful functions unique to SheetLink.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # Functions Powerful functions unique to SheetLink. | Function Formulas | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

=API("options")

Interact with any API

=API("")

| |

=cURL("cURL", "options")

Interact with any API (cURL format)

| |

=TasksLeft("#")

Number of SheetLink tasks left for the current sheet.

"#" (optional) - any value here will return # tasks left only

| {% hint style="info" %} Looking for SheetLink [pre-built app formulas](/formulas/apps)? {% endhint %} ### 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.

| |

💪 "options"

Control the request to and response from any application.

| ## 🚑 Need Help? You can always contact us via or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink) # "options" Control the request to and response from any application. {% hint style="info" %} All "options" must be a **cell reference** (B2), a **cell range** (B2:D2), or **comma separated in double quotes** ("option1","option2") {% endhint %} ### 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':'\VALUE\'}"

| |

cURL (or =cURL formula)

"\cURL-HERE\"

| |

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="

| |

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)

| {% hint style="success" %} You can try the [SheetLink pre-built app formulas](/formulas/apps), or our [=API("options")](/formulas/functions) to interact with any application API. {% endhint %} ### 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 or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink)