googleworkspace / apps-script-intro-codelab Goto Github PK

License: Apache License 2.0

JavaScript 100.00%

apps-script-intro-codelab's Introduction

Apps Script introductory codelab

This codelab introduces developers to Google Apps Script, our customized JavaScript-in-the-cloud application hosting platform which gives developers integrated access to G Suite, Google, and external services. Access it at http://g.co/codelabs/apps-script-intro.

Prerequisites

A Google account (G Suite accounts may require administrator approval)
Basic JavaScript skills
Basic spreadsheet skills

Introduction

The codelab introduces developers to one of the easiest ways to write code that accesses Google developer technologies, all by leveraging one of the mainstream web development languages, JavaScript. Using Google Apps Script, you will write code to extract an address sitting in a cell in a Google Sheet, generate a Google Map based on that address, and send a link of the map to yourself or a friend using Gmail. The best part? It's only 4 lines of JavaScript!

If you're completely new to Apps Script, check out our overview video. A longer intro video can be found here as well as another video walking you through the code in this codelab & repo.

Support

If you've found an error in this sample, please file an issue. Patches are encouraged, and may be submitted by forking this project and submitting a pull request through GitHub. See CONTRIBUTING for more information.

apps-script-intro-codelab's People

Contributors

Stargazers

Watchers

apps-script-intro-codelab's Issues

Fundamentals of Apps Script with Google Sheets #4 - API url update

Apologies for opening a report here instead of directly for the Codelab in question - I'm not seeing a bug report link there and cannot find the repo either. The code that is used to pull API data in step 7 (https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-4/#6) links to swapi.co, which is now defunct. A fork exists at swapi.dev, and updating the API url to use this value gets the code working again.

[SyncRepoSettings bot] - Invalid config file

Failed to validate the config schema at '.github/sync-repo-settings.yaml': [
{
"instancePath": "/permissionRules/1/permission",
"schemaPath": "#/properties/permissionRules/items/properties/permission/enum",
"keyword": "enum",
"params": {
"allowedValues": [
"pull",
"push",
"admin"
]
},
"message": "must be equal to one of the allowed values"
}
]

Schema can be found at https://github.com/googleapis/repo-automation-bots/blob/main/packages/sync-repo-settings/src/schema.json

Script Editor isn't under Tools menu now

The Script editor has moved to Extensions > Apps Script

Running sendMap function doesn't do anything

Running sendMap function doesn't do anything; you have to click "Run." for it to work.

Script editor not under tools

The script editor is no longer under Tools in Google Sheets, but under Extensions -> App Script

Small Documentation Typo

Found a small typo in this codelab's documentation.

On https://codelabs.developers.google.com/codelabs/apps-script-intro/#4, in the paragraph below this line of code:

var sheet = SpreadsheetApp.getActiveSheet();

The text and assigns to the value to the variable address. should be and assigns the value to the variable address..

I'd submit a PR, but I don't see the documentation in this repo.

tutorial example code does not work: API credentials needed?

I tweaked the script to populate a cell with the mapURL:

function sendMap() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var address = sheet.getRange('A1').getValue();
  var map = Maps.newStaticMap().addMarker(address);
  sheet.getRange("A2").setValue(map.getMapUrl());
}

The script works, but the url leads to a page which displays the following html:

The Google Maps Platform server rejected your request. You must use an API key to authenticate each request to Google Maps Platform APIs.

I could not find any info on where to set the Google Maps API key on Google Scripts documentation.

App blocked

Once I run this code I receive this error message and the authorization page is not shown.

6:58:52 PM Warning This project requires access to your Google Account to run. Please try again and allow it this time.