Better Sheets

UrlFetchApp

What it does

Make HTTP requests to external APIs and webhooks.

Methods used

.fetch() .getContentText()

6 Related snippets

Official Google docs

Explore

Related methods

.fetch()
Sends an HTTP request to a URL and returns the response.
.fetchAll()
Sends multiple HTTP requests in parallel.
.getHeaders()
Returns the HTTP headers from a response.
.getContentText()
Reads the response body as text.
.getResponseCode()
Returns the HTTP status code from a response.

More Apps Script

3 Better Sheets tutorials

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with AP...

Intermediate

COUNTIF() IF() IMAGE() ISBLANK()

Access the Dictionary API to get Definitions for Words in Google Sheets

Advanced

Automatic Screenshots in Apps Script

Advanced

Related blog posts

Written guides about UrlFetchApp in Google Apps Script.

Browse the blog

Extract URLs from Google Sheets

Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.