Skip to content

Instantly share code, notes, and snippets.

@ivazin
ivazin / Apps_Script_log_json.js
Last active May 24, 2023 23:32
Apps Script to neat log JSON data to a table
/*
Step 1: Create a new Google Sheets document.
Step 2: Open the script editor by going to "Extensions" -> "Apps Script" in the menu.
Step 3: In the script editor, delete any existing code and write the following code:
Step 4: Save the script by clicking on the floppy disk icon or using "File" -> "Save".
Step 5: Deploy the script as a web app by going to "Publish" -> "Deploy as web app" in the menu.
Configure the deployment settings as follows:
Project version: New
Execute the app as: Me
Who has access to the app: Anyone, even anonymous