UrlFetchApp

What it does

Make HTTP requests to external APIs and webhooks.

Methods used

.fetch() .getContentText() .getResponseCode()

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

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

Build a Book Recommender with AI in Google Sheets

Create an Email form that sends a few books to AI and gets back a book r...

Advanced

Build a Startup Pitch Generator in 20 minutes

Build a fully functioning AI powered startup pitch generator in 20 minut...

Intermediate

Building an AI Prompts Playground

Access the OpenAI API, walkthrough of the way we engineer the Apps Scrip...

Advanced

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and c...

Advanced

SUBSTITUTE()

Build Your Own Free Domain Availability Checker

Built a Domain Availability Checker in Google Sheets. You can build your...

Advanced

ARRAYFORMULA() FILTER() IF() ISBLANK()

ChatGPT Clone in Google Sheets Part 1

In this tutorial, learn how to create a ChatGPT-like interface using Goo...

ChatGPT Clone in Google Sheets Part 2

We fix the problem of OpenAI's API not remembering our last questions. A...

Advanced

Create a ChatGPT Cheat Sheet Spreadsheet

Walk through step-by-step going from a blank sheet to an AI powered prom...

Intermediate

CONCATENATE() COUNTIF() IF() ISBLANK() LEN() +2 more

Create a Waterfall of AI Prompts and Responses

This is an attempt to create a waterfall effect in sheets. Where an AI r...

Advanced

IF() INDIRECT() ISBLANK()

Created a GPT function in Sheets

Unlock the Power of OpenAI: Create Ultimate GPT Prompts for Seamless Int...

Advanced

Daily Writer's Word Count Tracker

Walk through creating an awesome automatic word count tracker that's eas...

Intermediate

CONCATENATE() COUNTIF() ROUND() SUM() TEXT() +1 more

Fast FAQS

New Tool for you: Fast FAQs. Create a quick 10 question FAQ for any new ...

Google Maps Scraper for Outreach

Get this fun template to search on google maps via API, and quickly mess...

Intermediate

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets

Intermediate

How To Download All Tabs as CSV in a Zip File

Download All Tabs as CSV in a Zip File, instead of downloading each one ...

Intermediate

How to Validate Email Addresses

I will show you how to validate email addresses using the Mailboxlayer ...

Intermediate

I Built a SEO Meta Description Writer

Unlock the Secrets of SEO Meta Descriptions! Learn how to craft compelli...

Advanced

IF() IMPORTXML() INDEX() ISBLANK() LEN() +1 more

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which...

Intermediate

IMAGE()

Make AI-generated Poems Based on Name

Create simple poems based on someone's name with AI. AI Apps Script Code...

Intermediate

Mr. Beast Renamed My YouTube Titles

I need help to supercharge my YouTube channel! Are you struggling to fin...

Advanced

INDEX() JOIN() ROW()

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your da...

Intermediate

IF() ISBLANK() SUBSTITUTE()

OpenAI API Prompt with Array of Cells

Create a prompt to OpenAI with an array of cells

Intermediate

CONCATENATE()

Perfect Use of AI in Google Sheets (Categorize Tasks)

Explore how to use AI for task categorization in Google Sheets, from set...

Intermediate

Prompt Parade

Create an epic writing tool to generate text from AI with a parade of pr...

Advanced

CONCATENATE() IF() ISBLANK() JOIN()

Quickstart Tutorial OpenAI API in Google Sheets

Use the power of OpenAI's GPT-3 inside of Google Sheets. In this quick s...

Run 100 ChatGPTs at One Time

Create a ChatGPT prompt inside a sheet, edit that prompt with a single i...

Intermediate

IF() ISBLANK() SUBSTITUTE()

Saving OpenAI API Calls inside of Google Sheets

Copy text output and input into a google sheet from your OpenAI API call...

Intermediate

Scrape Google Maps

Scrape any query in Google Maps into your Google Sheets. Enter your API ...

Intermediate

Scrape Google Maps Added Phone and Reviews

Added two helper functions to get Phone numbers and reviews of the Googl...

Shaman: AI Blog Writer

I will introduce you to the power of AI writing in Google Sheets using a...

Intermediate

Spreadsheet Automation for Beginners

I start off this video with the idea to show beginners how to automate e...

Beginner

INDEX() SPLIT()

Take Screenshots from URLs in Google Sheets

Use Screenshot One api to quickly get cached images of Screenshots and t...

Intermediate

IMAGE()

Tweet From a Sheet

See how to tweet from a sheet and get the code below.

Ultimate Headline Writer with GPT in SHEETS

Create the Ultimate Headline Writer: Unleash the Power of Google Sheets ...

Advanced

IF() ISBLANK()

Ultimate Prompt Writer and Prompt Rater

Create a chat interface inside of Google Sheets using GPT-4. Insert rows...

Data validation Advanced

FILTER() IFERROR()

Upgrade Google Sheets OpenAI Prompt to GPT 4

Upgrade to OpenAI's GPT 4 in your Google Sheets. And use GPT-3.5: Turbo ...

Advanced

LEN()

Use Random Quote API in Google Sheets

Learn how to add random movie quotes and famous quotes to a Google Sheet...

Intermediate

Visicalc 2023 Design Walkthrough

Design walkthrough of VisiCalc 2023. Watch this if you'd like to see the...

Intermediate

Visicalc 2023 Quick Walkthrough

This is a fun template I created for April 1st. Take a quick walk throug...

Beginner

SUM()

Explore

Related methods

More Apps Script

Access Free API's with Google Sheets

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

Automatic Screenshots in Apps Script

Build a Book Recommender with AI in Google Sheets

Build a Startup Pitch Generator in 20 minutes

Building an AI Prompts Playground

Build Your Own AI Writer in Google Sheets

Build Your Own Free Domain Availability Checker

ChatGPT Clone in Google Sheets Part 1

ChatGPT Clone in Google Sheets Part 2

Create a ChatGPT Cheat Sheet Spreadsheet

Create a Waterfall of AI Prompts and Responses

Created a GPT function in Sheets

Daily Writer's Word Count Tracker

Fast FAQS

Google Maps Scraper for Outreach

How to Create AI Images From Google Sheets

How To Download All Tabs as CSV in a Zip File

How to Validate Email Addresses

I Built a SEO Meta Description Writer

Learn to Code in Google Sheets, For Programmers

Make AI-generated Poems Based on Name

Mr. Beast Renamed My YouTube Titles

One Weird Google Sheet Formula for Bulk Publishing With AI

OpenAI API Prompt with Array of Cells

Perfect Use of AI in Google Sheets (Categorize Tasks)

Prompt Parade

Quickstart Tutorial OpenAI API in Google Sheets

Run 100 ChatGPTs at One Time

Saving OpenAI API Calls inside of Google Sheets

Scrape Google Maps

Scrape Google Maps Added Phone and Reviews

Shaman: AI Blog Writer

Spreadsheet Automation for Beginners

Take Screenshots from URLs in Google Sheets

Tweet From a Sheet

Ultimate Headline Writer with GPT in SHEETS

Ultimate Prompt Writer and Prompt Rater

Upgrade Google Sheets OpenAI Prompt to GPT 4

Use Random Quote API in Google Sheets

Visicalc 2023 Design Walkthrough

Visicalc 2023 Quick Walkthrough

Related blog posts

Extract URLs from Google Sheets