node-googl | A Node.js url shortener and expander powered by Google | Runtime Evironment library

I had to do some work with google sheets api and i found this popular package on npm to ease my work https://www.npmjs.com/package/google-spreadsheet . I have done my entire project with this package but then i was asked to do some formating to the spreadsheet (merging cells for exemple). The problem is that i haven't found anything interresting in the doc https://theoephraim.github.io/node-google-spreadsheet/#/ (about this subject). Does anyone knows how to format cells using this package ? Is it even possible ? thanks in advance

I am using the gpapi library in order to find the Play Store and store information about the apps found on the Play Store. I begin by finding the related apps of an app (about 20 apps), after which I request details about each one of them. This is done by the library as promise requests. I tried adding a delay between the requests, as in the current state, all the requests are executed simultaneously, thus I get a 429 error (too many requests), and after a while, I am temporarily completely banned from Google servers.

I keep getting node-pre-gyp and gyp errors when I try to deploy my Node.js application to Heroku:

I had managed to call these 2 methods (geocoder.reverse, timezone.data) one after the other successfully in V1 DialogflowApp, but I am now upgrading to V2, and can't seem to get both asynchronous method calls right. Please help. I use these packages respectively

• node-geocoder: ^3.22.0

• node-google-timezone: ^0.1.1

  ...

I´m not an expert in node-red and truly appreciate some help on using the node-red-node-google geocoding node. link to Google Geolocation node-red node

I'm trying to obtain the location address via google Geolocation API from previously obtained coordinates using the node mentioned above (geocode by coordinates option). I take latitude and length via POST from an external application.

How should the latitude and longitude data be fed into the geocode node to get the correct address data? After tens of tests, I always obtain the same error: "Invalid request. Invalid 'latlng' parameter". What I'm doing is:

1. Take data generated via POST http://my_public_ip:1880/geo?id={device}&time={time}&lat={lat}&lng={lng}&radius={radius} The first node of the flow is a node-red Http In node, that implements the htp end-point, gets the info from that callback. Te info is retrieved correctly (see debug output) : {"id":"18A834","time":"1503231980","lat":"40.xxxxxxxxxxxxxx","lng":"-3.xxxxxxxxxxxxxx","radius":"1651"} Note: coordinates shadowed by privacy reasons.
2. If lng and lat values from the HTTP In node are fed into the Google Geocoding node, the message error "Invalid request. Invalid 'latlng' parameter" is received.

I fill the dialog box this way:

Latitude text box: msg.payload.lat

Longitude Text box:msg.payload.lng

1. I have tried several options inserting the coords function node: convert the latitude and longitude values to float, keep only the first 7 decimals, convert again to strings ..., and always the same error is received: "Invalid request. Invalid 'latlng' parameter"

The coords function node configuration:

I've been puzzling over this loop for a few days and can't quite get to what I need.

I loop over my array of search results (mdb_results) and extract from each object a .name to use as a _search term in a Google CSE Image Search.

Th CSE returns another array (cse) which I want to append to the object from which I extracted the _search term (mdb_results[i]).

I created a new ASP.NET Empty Web Application in Visual Studios 2013. I have an angular project with the following directory structure: