@@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.
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!
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.
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.
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
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" } }
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.
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.
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!
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!
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
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.
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.
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
@@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. But i got error : google-api-php-client.ERROR: Service parameter missing {"service":"sheets","resource":"values","method":"get","p arameter":"spreadsheetId"} []
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?
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
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, 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
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 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?
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
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
Now that you know how to use Google Sheets with PHP, what will you build?
can i use in web?(i am really beginner :) )
@@oguz-kagan Absolutely! You could definitely use this in a web project.
good tourtorial, but for me is that bit difficult to write my php for a taxifare calculator
How could I get row by a specific value, for example, token or id?
@@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.
This is by far one of the BEST tutorials on UA-cam, you can argue with your keyboard.
Thank you! Probably the best done video tutorial. Clear, concise, perfect speed. Right amount of content & explanation
Thanks for watching and for the kind words. Hope it helped!
I agree
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!
Thanks for watching and for the kind words!
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.
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.
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
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 just finished my project in time thanks to your video. You saved me so much time. Thank you man. I mean it
I’m glad we could help!
I don't usually comment on videos. But this one really did it for me. Just perfect! Deserves more views!
Thanks for watching! Glad it was helpful 😀
this is actually better than the google documentation, which forgot to mention that the $insert parameter is needed.
Big thanks for this great short guide!
from where did u got the interface @0:14, i mean what is api, how to install ?
This was so helpful. I was running into issues on private shared drives with the v3 sheets api.
Thanks 👏👏
Glad we could help!
Thats was first video that really helped! Thnx!
Glad we could help! Thanks for watching 😀
Muchas gracias por compartir tus conocimientos. Que gran video!!
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" } }
did you find a solution? same problem here
Best tutorial, the pace is perfect for dummy like me, many thanks
what if i can't install composer and use ssh terminal?
Where did the black screen come from?
From where I can access it
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.
Thank you so much. Great tutorial. So much time saved.
Thanks for watching! I’m glad we could help you.
Sorry, but what can I run composer command with? It isn't cmd, right?
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.
This is 4 years old. A package I paid to have installed i 2019, died today "Token Expired or Revoked". Doesn't anything last?
Like like like! Just awesome! Thank you!
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!
Thank you very much, it's very simple and very useful!
Many Many Thank's Video helped a lot
Thank you very much, you helped me a lot!
Glad I could help!
Great video but has there been a change in creating credentials since this video as I do not get asked the same questions and cant get a json file
Very good Sir, I really like this video. very helpful. Thank you very much.
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!
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
witch color theme do you use ? could you send it to me i really like yours ?
Hi, this works great locally but when pushed live, I am receiving a 500 error "an unknown error occurred".
This is really great tutorial sir, Thank you so much @Twilio
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.
perfect. thanks ! I use it to generate ad scripts for my websites
Json file is not installed
why didn't you post your code?
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.
How do you install this without that composer?
I follow your tutorials. And i can run the code in local server. But when i run it with live server, it shows error 500 in console. Why this happen?
Same here! Did you ever figure it out?
@@ayyosefo yup. its the case sensitive in the code
test batch1 thanks! What exactly was case sensitive that was breaking live but not local? Is it the insert values? I appreciate your help
very nice. thank you
#ASK can i append random size of row to the upper of the table, so the row that build before, move to the bottom of new append row?
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 to run composer at 1:05
Compose is a dependency manager for PHP - you can find out more and install it at getcomposer.org
@@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. But i got error : google-api-php-client.ERROR: Service parameter missing {"service":"sheets","resource":"values","method":"get","p
arameter":"spreadsheetId"} []
Why I dont have client_email in my credentials file? I don't get it.
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?
Life saver! :D Thank you so much for the video
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
hi! what is the name of the application at 1.03-1.15 ??
It's iTerm 2 for the Mac.
How to install in localserver with xampp in windows?
youre the best thank you...
Composer can not find files any idea's?
@Twilio Great video but how can we do that with C#?
So simple and straigth forward ! Just what I needed, thanks a lot !
How can you search a row based on a cell value ?
Really good video. Thank you!
Thank you very much, you saved my day!
man youre my hero :D thanks!
Glad we could help!
Can you do this without using Composer?
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.
E and F are columns. He is updating first name and last name in one row (row 2).
@@rsturks Ya I know but my question is how to update two first name or two last name?
Thanks, this is so good. You won a new suscriptor
Thanks for watching and for the sub!
I think google should hire you for the documentation and product's demo engineer.
Hello Can we make search in a sheet on php?
How do you implement a workaround for 'too many request' with error code 429 aside from upgrading the account?
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 we are actually hitting the limit because we have a lot of users triggering the API, but I need to do some workaround about it. hmmm
Hello, Where can i find credentials.json file?
i'm try to use it on a cpanel hosted server but it does not work. why?
any link to the written code?
this is awesome man ! thanks!
@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
Thanks ,Worked for me
What program do you use for PHP editing? It's really nice.
seems like visual studio code
Visual Studio Code, he says so in the video @ 1:17
Yep, VS Code.
Thank you guys
Thanks you so much!! Is excelent, thank you
Why are you using "print"? Why not "echo"?
I did use echo. First I formatted the string with sprintf (www.php.net/manual/en/function.sprintf.php) and then used echo.
This video helped alot! thanks!
We're glad you found it useful, thanks for watching!
Great video but how can we do that with C#?
I wasn't able to get further...needs OAuth 2.0
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.
Hit me up on Twitter @GeeH and I'll give you some help ^G
Awesome thank you!!!
You're welcome, thanks for watching!
Why does my quickstart fail? Google's document is worse than instructions from users? you are great, thank you so much
how can i create a new google sheet as i want to export table data as google sheet ?
I think you will need to use the Google Drive API to do this.
Dude, i'm getting Warning: count(): Parameter must be an array or an object that implements Countable..
you should give a link to your code you have used
how to delete rows or columns
I wanna know is the credentials service account is a lifetime or would be expired?
As far as I know the service account does not expire.
@@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?
@@macare-engineering8379 That's showing you how many times the Service Account has been used to make an API call in the past 30 days.
where i con found the credentials.json?
The credentials file is something you download from the Google Cloud console in the last step of setting up the API project shown in the video.
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
how to add comments into cell. no code found
BEST VIDEO EVER S2
download script ? tnhks im from Brasil,
Thank you
Muito bom tutorial... adorei.
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
I am getting exception error, please help me
Hi! Need more info than that to be able to help. What’s the error message you’re getting?
THANKS! GOOD MAN!
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"
}
kindly guide me I am blocked
I’m going to need more information than that to be able to help. What have you tried to fetch? What line of code is throwing this error?
@@twilio $response =$service->spreadsheets_values->get($spreadsheetId, $range);
@@honoremwiseneza2970 Please did you find the solution ?
@@kendouciabdelaliilyas No I didn't
Thanks a lot!
This is out of date. Service accounts don't have json exports evidently.
is google API free?