Category "google-sheets-api"

Connect to googlesheets via shiny in R with googlesheets4

I'm trying to use an updated version of this example to connect to a private googlesheet via shiny, and deploy this app on the shinyapps.io server. The user is

Importing API data via importJSON

Having a bit of trouble using importJSON for the first time in Google Sheets. My data is importing as truncated and I can't find any way to really filter things

Merge spreadsheets via API?

I have a use case with a "master" Sheets file on Google Drive, and a new Sheet is emailed to a User, who then copy and pastes the data from the emailed sheet in

curl: (3) [globbing] nested brace in column 189 when sending PUT request to Google Sheets API

I am trying to write to a Google Spreadsheet using Google Sheet API v4. The usage about the API is listed here I made a curl request that looks like the follo

Convert this array formula for google spreadsheet

I found out that you can't use an array formula if you are using the "if" "and" "or" formula on google spreadsheet. Can someone please help me fix this formula

Access Google Sheets on Google Colaboratory

Hi I am using Google Colaboratory (similar to Jupyter Notebook). Does anyone know how to access data from Google Sheets using Google Colaboratory notebook?

Google Sheets API: How to find a row by value and update it's content

I am working on an Android application that uses a Google Spreadsheet as a database. The application should GET, APPEND and UPDATE values in a spreadsheet, usi

How to resolve "This app is blocked" error for shared Google Apps Script library?

I'm trying to create a Google Apps Script (GAS) library that I can reuse across my Google Sheets spreadsheets. Following these instructions, here's what I've do

Google apps script not identifying sheet correctly

I'm running a templated google script that constructs an html page with the contents of a google spreadsheet. When I run the script with the spreadsheet https:

I need to link Google Sheet with my Laravel

i want to link my laravel app with Google sheet i use this package : Google Sheets API v4 for Laravel my function : public function doPostData(){ $

Insert a row in the middle of existing data

I'm trying to insert an empty row in the middle of the spreadsheet using node.js and Google Sheets API v4. I've been researching everywhere for past few days, b

How do I access (read, write) Google Sheets spreadsheets with Python?

I am wondering if you can point me to an example of reading/writing to/from a google doc/spreadsheet using python. I did look at google docs API here https://

403 Forbidden Error from google API Javascript client

I am getting 403 Forbidden Error from google API Javascript client. Following is my code: gapi.load('client', function () { console.log('gapi.client loaded

Get date value from header

I'm trying to use Google Sheets as a JSON backend. The JSON output is here: "gsx$company": { //all is ok "$t": "Company name"

How can I create an unlimited range for cloud functions?

I'm creating a cloud function to read a google spreadsheets and I want that use an unlimited range. It´s that possible? The idea is read the Google spread