@@twilio Hi, First of all Thank you so much for this awesome video. I have one question, at 5:15 you are talking about updating E2 and F2 (Two Rows) but how can I update E2 and E3 (Two Columns). Can you guide me? Thanks.
amazing tutorial, thanks, 8 minutes and you're on handling google sheets from PHP. Since the tutorial was written google console changed a bit in the fact that the JSON file will no longer be given to you at the completion of the config screen as in the video, you need to go under keys -> create -> and then download the credentials file.
This is literally the greatest video in existence. Perfectly done, right to the point and covered all bases. Stanley Kubrick could learn a thing or two from you guys. Thanks for the great info!
tried to read different online tutorials and following documentation and their code on Github and couldn't find what I want, so I decide to watch this video as last try. You explanation is clear, structured, organized, beyond what I wanted and expected. thanks a lot
Thank you for all that you do. In fact, google should recommend this video as their official documentation. It's much easier to understand than the gibberish they wrote on their official page. You're just the best. You've saved me a lot of time.
i have a problem at 5:00, i have this error: PHP Fatal error: Uncaught GuzzleHttp\Exception\RequestException: cURL error 60: SSL certificate problem: unable to get local issuer certificate can you help me pls??
I did all that and after I try to run it to read the data from spreadsheet I got Fatal error: Uncaught Google\Service\Exception: { "error": { "code": 404, "message": "Requested entity was not found.", "errors": [ { "message": "Requested entity was not found.", "domain": "global", "reason": "notFound" } ], "status": "NOT_FOUND" } }
Thanks for the tutorial. It sounds so simple... I wish it was easier. I have no knowledge of running things in the terminal. It would be helpful if you could make the commands you use available for copy/pasting
This video has been so awesome in getting me going with the PHP library, so thank you for all of the information! That said, I have a question. In the first example where we're simply trying to get some cells from the sheet, you call the 'GetValues()' function. In trying to use this knowledge to do other things with different API's (Drive and Photos, for example), I can't seem to use this. In my file system (within the PHP library), I'm trying to understand exactly where this 'GetValues()' method is defined, and what I would instead use in other API's. Can you offer any insight here? Thanks for your time and for the great content!
If you are on Windows, there's a full guide on installing PHP (including composer) here: www.jeffgeerling.com/blog/2018/installing-php-7-and-composer-on-windows-10
Hey! I'm adding rows in Google Sheets and would love to check if all data from PHP database has been successfully been added into Google Sheet by searching one by one via the ID.
Are you using Windows or Mac? This is a terminal emulator window. On a Mac you would use an app called Terminal. On Windows you can use either Command Prompt or Powershell.
Hi I'm getting some errors with the "autoload.php". I received error with "guzzlehttp". I think that I have too much libraries declare with composer. Did you know how I could create that file again without those libraries? Thanks!
Hey, do you have an solution for filtering? I mean I want to get values like this but string value in let's say 3rd column must be exactly "X". I can't find any solution for this
The data sets I’ve worked with using this have been small enough that I’ve just done filtering locally. I’m also having a hard time finding how to do it in the API. Seems like a simple feature. There’s developers.google.com/sheets/api/reference/rest/v4/spreadsheets/getByDataFilter but it doesn’t seem to do what we want.
Thanks you sooooooo much. I tried Quick Start Tutorial of Google but it not work for append data. I started slowly. The tutorial of GG is not good enough for ' A real Quick Start' , but your video is. Thank bro
Guys, it works locally, but I get error email 'Domain name not found' when deploying and it ends for me there. The funny thing is that I can't find any thread to look up what might be the issue.
would u like to tell how to get all lists of google sheet with their name and id using php? i can see you have put hard coded google sheet id so i need it dynamic please
Thanks. But i got error : google-api-php-client.ERROR: Service parameter missing {"service":"sheets","resource":"values","method":"get","p arameter":"spreadsheetId"} []
i did the same as you did but $this->service->spreadsheets_values->get($this->documentId, $this->range); giving me this error : array_key_exists(): Argument #2 ($array) must be of type array, null given
How can make it work the next function?: My spreadsheet is bonded with a google form wich every day is inserting new rows with a lot of data, but, there is a column wich is blank because i need to insert a verification value (maybe just like "Ok" or "this person asist the citation") in that column for every row that is inserted but i need to insert that verification value via another html form, but i dont know how to do it, because i need to put the Date when that person fillls the main form and the ID of that person and then specify to the php to insert that verification value only in the cell wich is in the same row with the Date and the ID that i put in the verification form, anyone can guide me here?
Hi, First of all Thank you so much for this awesome video. I have one question, at 5:15 you are talking about updating E2 and F2 (Two Rows) but how can I update E2 and E3 (Two Columns). Can you guide me? Thanks.
You are probably hitting the rate limit for the API. It’s possible you might just need to slow down the speed at which you are making requests to the API.
@@twilio Well, when you go to google developer console ->Credentials you will see "Usage with all services(last 30 days)" beside Service Accounts. What's that mean?
Hello, the video helped me to understand the API, but it marks the following error: Uncaught Error: Class 'Google_Services_Sheets', Could you help? please.
@twilio, firstly thank you for the great concept, have been implementing it i'm stuck at this error, trying them out, can you please help me out here, I'm trying to Read and Update(mandatory) the Data in the GoogleSheet using API with PHP Here is the error, Fatal error: Uncaught Google_Service_Exception: { "error": { "code": 403, "message": "The request is missing a valid API key.", "errors": [ { "message": "The request is missing a valid API key.", "domain": "global", "reason": "forbidden" } ], "status": "PERMISSION_DENIED" } } in C:\xampp\htdocs\ww\googleapiconnector\vendor\google\apiclient\src\Google\Http\REST.php:118 Stack trace: #0 C:\xampp\htdocs\ww\googleapiconnector\vendor\google\apiclient\src\Google\Http\REST.php(94): Google_Http_REST::decodeHttpResponse(Object(GuzzleHttp\Psr7\Response), Object(GuzzleHttp\Psr7\Request), 'Google_Service_...') #1 C:\xampp\htdocs\ww\googleapiconnector\vendor\google\apiclient\src\Google\Task\Runner.php(181): Google_Http_REST::doExecute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google_Service_...') #2 C:\xampp\htdocs\ww\googleapiconnector\vendor\google\apiclient\src\Google\Http\REST.php(58): Google_Task_Runner->run() #3 C:\xampp\htdocs\ww\googleapiconnector\v in C:\xampp\htdocs\ww\googleapiconnector\vendor\google\apiclient\src\Google\Http\REST.php on line 118
@@twilio I expected a better response I got stuck at the same exact place where it says "inside my project directory I will use composer" but you skipped to show what you did to launch composer and it does not appear in the video but only shows the composer already being used. I do not know what know how to locate the project directory or where the composer is located within my windows 10. The whole point of a tutorial is to show us exactly how to do it not go read it somewhere as some of us are visual learners only. Can you send me the video of that part that was removed.
Thanks for this great video. it works perfectly locally but when i upload my project on server it does not work. is there anyone who have same issue? thanks