How can we help you?

Search results for:Google App Script

Set refresh rate for Spreadsheets widgets powered by import functions

Set your own refresh interval by using Google Apps Script… In your Google Sheet, click on Tools > Script Editor… In your Google Sheet, click on Tools > Script Editor

Use Google Apps Script to import Stripe data to Google Sheets

Steps to create a Stripe widget using data from Google Sheets… In this article, we'll use the Google Apps Script platform to get data from Stripe into Google Sheets… Metrics available with this script

Use Google Apps Script to import Richpanel data to Google Sheets

Learn how to use a script to automatically get data from Richpanel into Google Sheets… In this guide, we'll cover how to use Google Apps Script to fetch ticket data from Richpanel and bring… Make a copy of this Google Sheet. Navigate to Extensions > Apps Script

Display Google Calendar events on your dashboard via Google Sheets

Learn how to use a Google Apps Script to get Google Calendar event data into Google Sheets… Use the Google Apps Script platform to automatically fetch the next 10 events from a Google Calendar… in Google Sheets and then display them in a table widget

Import Mixpanel data to Google Sheets

Options for automatically importing Mixpanel data into Google Sheets… This Google Apps Script allows you to automatically fetch data from Mixpanel and bring it into a Google… Use Google Apps Script

Send data from Google Sheets to Datasets

Step 1: Add the Google Apps Script library to your Google Sheet… your data to the Datasets API in Geckoboard using Google Apps Script… Open your Google Sheet containing your data. Navigate to Extensions > Apps Script

Connect data to Geckoboard from any source

Sheet Google Sheets Apps Script Anyone with Apps Script knowledge Use JavaScript built… Sheets to Dataset Anyone Push data from a Google Sheet to a dataset using our Apps Script; useful… Automation apps

Display Xero metrics in Geckoboard using datasets and Zapier

Upload the CSV file to Google Drive and open it with Google Sheets… Navigate to Extensions > Apps Script… default code: function myFunction() { } Copy and paste the following code block into the Script

Use ImportRange to extract data needed for Geckoboard to a new spreadsheet

Learn how to use Google Sheets ImportRange function to import data… If this isn't fast enough for your needs, you can use Apps Script within your Google Sheet to speed up… Within your Google Sheet, click the Extensions menu, then Apps Script

Push to Custom Widgets from a Google Sheet

Steps to use a Google Sheets script that pulls data from a sheet, before pushing the data to a Custom Widget… In this article, we'll demonstrate a Google Sheets script that pulls data from a sheet before pushing… Create a new Google Sheet. Click on Tools > Script editor