BinaryEye icon indicating copy to clipboard operation
BinaryEye copied to clipboard

Published 20 hours ago • verified publisher icon markusfisch

Send code to google sheets

Open Natalia-Oreiro opened this issue 3 years ago • 5 comments

Hi, I am very newbies, can you please advise me how to send codes (GET and POST) to google sheets? best option for me, where I can click without using programming knowledge.

thanks.

Natalia-Oreiro avatar Aug 12 '21 09:08 Natalia-Oreiro

I think you can make Google Forms accept HTTP requests, but I'm not an expert on Google Forms or Sheets. But there's probably a lot info on that on Google 😉

A simpler alternative may be to just collect the scanned codes in the history and export the history (with the export action button in the top right). The history can be exported in CSV format (or JSON or as a SQLite database), which can easily be imported into Google Sheets.

markusfisch avatar Aug 12 '21 16:08 markusfisch

I found some information, but nothing specific..

is it possible to use google API? https://console.cloud.google.com/projectselector2/apis/

Natalia-Oreiro avatar Aug 30 '21 20:08 Natalia-Oreiro

Well, yes, it sure is possible. But I would think you would want to use the Google Sheets API if you want to put the scanned code in a Google Sheet.

Here are some samples of how to use this API: https://developers.google.com/sheets/api/samples

I think this is the endpoint you want to use: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append

So, in Binary Eye, you would use an address like "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append" with the type "POST application/json". Unfortunately, the JSON format the Google Sheets API requires isn't compatible with what Binary Eye is sending. So this can't work at the moment, at least not directly, sorry.

It would be possible to add a custom JSON template for this 🤔

markusfisch avatar Aug 31 '21 19:08 markusfisch

Thanks for the info! I'll start learning how to use the Google Sheets API :-D

i love your app it would be so awesome to associate with google sheets. I will be very happy for any other knowledge that would help me :-)

Natalia-Oreiro avatar Sep 09 '21 09:09 Natalia-Oreiro

Google App Scripts allow you to create a web service that will allow you to receive requests from BinaryEye. With this, you don't need anything other than a Google Sheet and a Google Sheet for this

DienoX avatar Dec 30 '22 13:12 DienoX