@@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!
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.
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.
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" } }
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!
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.
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
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
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
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!
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?
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
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.
@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. But i got error : google-api-php-client.ERROR: Service parameter missing {"service":"sheets","resource":"values","method":"get","p arameter":"spreadsheetId"} []
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.
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
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.
@@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 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
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 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.
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 RUclips, you can argue with your keyboard.
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!
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.
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
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.
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 😀
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??
Big thanks for this great short guide!
this is actually better than the google documentation, which forgot to mention that the $insert parameter is needed.
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
This was so helpful. I was running into issues on private shared drives with the v3 sheets api.
Thanks 👏👏
Glad we could help!
This is 4 years old. A package I paid to have installed i 2019, died today "Token Expired or Revoked". Doesn't anything last?
what if i can't install composer and use ssh terminal?
Thats was first video that really helped! Thnx!
Glad we could help! Thanks for watching 😀
Best tutorial, the pace is perfect for dummy like me, many thanks
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!
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.
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
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.
witch color theme do you use ? could you send it to me i really like yours ?
Muchas gracias por compartir tus conocimientos. Que gran video!!
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
How do you install this without that composer?
Like like like! Just awesome! Thank you!
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
Thank you very much, it's very simple and very useful!
@Twilio Great video but how can we do that with C#?
Can you do this without using Composer?
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.
from where did u got the interface @0:14, i mean what is api, how to install ?
perfect. thanks ! I use it to generate ad scripts for my websites
Thank you very much, you helped me a lot!
Glad I could help!
Many Many Thank's Video helped a lot
why didn't you post your code?
Composer can not find files any idea's?
This is really great tutorial sir, Thank you so much @Twilio
#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?
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
So simple and straigth forward ! Just what I needed, thanks a lot !
How can you search a row based on a cell value ?
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!
Json file is not installed
Hi, this works great locally but when pushed live, I am receiving a 500 error "an unknown error occurred".
Great video but how can we do that with C#?
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?
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
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.
Why does my quickstart fail? Google's document is worse than instructions from users? you are great, thank you so much
Why I dont have client_email in my credentials file? I don't get it.
Really good video. Thank you!
Hello, Where can i find credentials.json file?
Hello Can we make search in a sheet on php?
any link to the written code?
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
I wasn't able to get further...needs OAuth 2.0
very nice. thank you
I think google should hire you for the documentation and product's demo engineer.
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
Life saver! :D Thank you so much for the video
Thanks, this is so good. You won a new suscriptor
Thanks for watching and for the sub!
i'm try to use it on a cpanel hosted server but it does not work. why?
you should give a link to your code you have used
@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
Thank you very much, you saved my day!
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.
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?
Thanks. But i got error : google-api-php-client.ERROR: Service parameter missing {"service":"sheets","resource":"values","method":"get","p
arameter":"spreadsheetId"} []
youre the best thank you...
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
man youre my hero :D thanks!
Glad we could help!
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
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.
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?
this is awesome man ! thanks!
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.
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.
how to add comments into cell. no code found
Thanks you so much!! Is excelent, thank you
Thanks ,Worked for me
how to delete rows or columns
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
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
This video helped alot! thanks!
We're glad you found it useful, thanks for watching!
Dude, i'm getting Warning: count(): Parameter must be an array or an object that implements Countable..
Muito bom tutorial... adorei.
Awesome thank you!!!
You're welcome, thanks for watching!
download script ? tnhks im from Brasil,
More easy than in 2010
Thank you
is google API free?
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.
BEST VIDEO EVER S2
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?
Thank you so much
You’re welcome!
Thanks a lot!
github?