google-spreadsheet-reader | Reads data from a Google Spreadsheet | Data Visualization library

by juampynr PHP Version: Current License: MIT

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | google-spreadsheet-reader Summary

google-spreadsheet-reader is a PHP library typically used in Analytics, Data Visualization applications. google-spreadsheet-reader has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

This project contains a sample script that uses a service account to authenticate against Google Spreadsheets in order to read the content's of a spreadsheet.

Support

Quality

Security

License

Reuse

Support

google-spreadsheet-reader has a low active ecosystem.

It has 50 star(s) with 14 fork(s). There are 1 watchers for this library.

It had no major release in the last 6 months.

google-spreadsheet-reader has no issues reported. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of google-spreadsheet-reader is current.

Quality

google-spreadsheet-reader has 0 bugs and 0 code smells.

Security

google-spreadsheet-reader has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

google-spreadsheet-reader code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

google-spreadsheet-reader is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

google-spreadsheet-reader releases are not available. You will need to build from source code and install.

Installation instructions, examples and code snippets are available.

google-spreadsheet-reader saves you 3 person hours of effort in developing the same functionality from scratch.

It has 11 lines of code, 0 functions and 1 files.

It has low code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of google-spreadsheet-reader

Get all kandi verified functions for this library.

google-spreadsheet-reader Key Features

No Key Features are available at this moment for google-spreadsheet-reader.

google-spreadsheet-reader Examples and Code Snippets

No Code Snippets are available at this moment for google-spreadsheet-reader.

Community Discussions

Trending Discussions on google-spreadsheet-reader

Service Account for google sheets returns not found

QUESTION

Service Account for google sheets returns not found

Asked 2019-Mar-22 at 05:28

I am trying to read a spreadsheet using a service account (I cannot use OAuth, which works, since the process will be running on a server to periodically check sheet data)

I tried several approaches. If I follow the example using oauth I can see the sheet values. However, I need the run the script without any GUI on the background.

I have found this tutorial https://github.com/juampynr/google-spreadsheet-reader I have created a projec, service account, added viewer role, shared the spreadsheet with the service account email. Generated the key. It seems that the test program can connect to the google services but the moment it request the spreadsheet the end result is "404 not found".

...

ANSWER

Answered 2019-Mar-22 at 05:28

When the access token retrieved by OAuth2 is used, the Spreadsheet of $spreadsheet_id = '1TAWybckPrnWlQxBZh0ScDsFOvftwi2dvTBNGarSdY30'; can retrieve the values.
When the access token retrieved by Service Account is used, Error 404 (Not Found)!!1 is returned.

If my understanding is correct, please confirm the following points.

Confirmation points:

As a test run, please set the range $spreadsheet_range = '';.
- For example, it's $spreadsheet_range = 'Sheet1'.
If the error message of The caller does not have permission is returned, please confirm as follows.
- Whether the Spreadsheet of 1TAWybckPrnWlQxBZh0ScDsFOvftwi2dvTBNGarSdY30 is sharing the email of Service Account.
- If you didn't share the Service Account to the Spreadsheet, please share the email of client_email in the file of readsheetmar2019-08b737d1c1cb._portfolio_test.json to the Spreadsheet you want to access.
If the error message of Google Sheets API has not been used in project ### before or it is disabled. is returned, please enable Sheets API.

If this was not the solution for your issue, I apologize.

Source https://stackoverflow.com/questions/55213638

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install google-spreadsheet-reader

Start by creating a service account at the Google Developer Console:. You should see the raw contents of the spreadsheet.
Open https://console.developers.google.com/apis/library
Enable it and create a project:
At Credentials, create a service account:
Keep defaults at the next form and click Create. Save the resulting private key file in a directory where your application can read it:
Next, click on “Manage Service accounts”:
Copy the email address of your service account:
Grant permission to the service account to the spreadsheet:
Read the contents of index.php and fill out the required variables. Then execute it with:

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: