Google Sheets and PHP

[@twilio]

Now that you know how to use Google Sheets with PHP, what will you build?

[@oguz-kagan]

can i use in web?(i am really beginner :) )

[@twilio]

@@oguz-kagan Absolutely! You could definitely use this in a web project.

[@netboy1102]

good tourtorial, but for me is that bit difficult to write my php for a taxifare calculator

[@maximusTVfull]

How could I get row by a specific value, for example, token or id?

[@RajPatel-uh9nd]

@@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.

[@chrismuiruri]

This is by far one of the BEST tutorials on KZbin, you can argue with your keyboard.

[@Franzisss_001]

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??

[@anaskanhouch478]

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

[@12centuries]

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!

[@twilio]

Thanks for watching and for the kind words!

[@ujirooduokpe8243]

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.

[@arunvr1608]

Thank you! Probably the best done video tutorial. Clear, concise, perfect speed. Right amount of content & explanation

[@twilio]

Thanks for watching and for the kind words. Hope it helped!

[@darthleonard]

I agree

[@vladagrigoroae1767]

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.

[@d4Hya]

I just finished my project in time thanks to your video. You saved me so much time. Thank you man. I mean it

[@twilio]

I’m glad we could help!

[@xCalecax]

I don't usually comment on videos. But this one really did it for me. Just perfect! Deserves more views!

[@twilio]

Thanks for watching! Glad it was helpful 😀

[@newborn7850]

from where did u got the interface @0:14, i mean what is api, how to install ?

[@toriskin]

Big thanks for this great short guide!

[@candreadiazs]

Muchas gracias por compartir tus conocimientos. Que gran video!!

[@HD-qc5vv]

Where did the black screen come from? From where I can access it

[@twilio]

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.

[@debaterg]

this is actually better than the google documentation, which forgot to mention that the $insert parameter is needed.

[@cpukid00]

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!

[@onebitrocket]

This was so helpful. I was running into issues on private shared drives with the v3 sheets api. Thanks 👏👏

[@twilio]

Glad we could help!

[@NickBaer-gu5mb]

This is 4 years old. A package I paid to have installed i 2019, died today "Token Expired or Revoked". Doesn't anything last?

[@acidfather]

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" } }

[@lucku0]

did you find a solution? same problem here

[@johnboy4809]

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

[@NicopolSpirit]

Thats was first video that really helped! Thnx!

[@twilio]

Glad we could help! Thanks for watching 😀

[@cooldown6337]

what if i can't install composer and use ssh terminal?

[@matheusaugus9855]

witch color theme do you use ? could you send it to me i really like yours ?

[@Nguyen-go2vw]

Sorry, but what can I run composer command with? It isn't cmd, right?

[@twilio]

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

[@hanibioud]

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.

[@RajPatel-uh9nd]

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.

[@rsturks]

E and F are columns. He is updating first name and last name in one row (row 2).

[@RajPatel-uh9nd]

@@rsturks Ya I know but my question is how to update two first name or two last name?

[@antonitobing]

Best tutorial, the pace is perfect for dummy like me, many thanks

[@kaipro98hii67]

how to run composer at 1:05

[@twilio]

Compose is a dependency manager for PHP - you can find out more and install it at getcomposer.org

[@OsielyMendezpluskids]

@@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.

[@faisalzubair5065]

@Twilio Great video but how can we do that with C#?

[@JK-pr3lu]

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

[@testbatch1141]

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?

[@ayyosefo]

Same here! Did you ever figure it out?

[@testbatch1141]

@@ayyosefo yup. its the case sensitive in the code

[@ayyosefo]

test batch1 thanks! What exactly was case sensitive that was breaking live but not local? Is it the insert values? I appreciate your help

[@santiagovalenzuela6651]

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!

[@ayyosefo]

Hi, this works great locally but when pushed live, I am receiving a 500 error "an unknown error occurred".

[@jjasonryszka6267]

Thank you so much. Great tutorial. So much time saved.

[@twilio]

Thanks for watching! I’m glad we could help you.

[@evgenyvorontsov3526]

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.

[@tusharvaghasiya3156]

Very good Sir, I really like this video. very helpful. Thank you very much.

[@adrianzubir7007]

#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?

[@programming_with_zahid]

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

[@kornelijekovac9793]

How do you install this without that composer?

[@elmsroth8850]

So simple and straigth forward ! Just what I needed, thanks a lot ! How can you search a row based on a cell value ?

[@Dvoini]

why didn't you post your code?

[@arbysixteen4116]

hi! what is the name of the application at 1.03-1.15 ??

[@twilio]

It's iTerm 2 for the Mac.

[@jaypatel1809]

How to install in localserver with xampp in windows?

[@favorevole]

What program do you use for PHP editing? It's really nice.

[@ftapia]

seems like visual studio code

[@redhotmustang]

Visual Studio Code, he says so in the video @ 1:17

[@twilio]

Yep, VS Code.

[@favorevole]

Thank you guys

[@armanmargaryan6883]

Thank you very much, it's very simple and very useful!

[@YuriiKosiak]

Like like like! Just awesome! Thank you!

[@Allformyequine]

Can you do this without using Composer?

[@e-learnpro1561]

Many Many Thank's Video helped a lot

[@tomatomov9061]

Why I dont have client_email in my credentials file? I don't get it.

[@gokulr8924]

Json file is not installed

[@Mr_MadZac]

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?

[@AbhishekKumar-yr5eo]

This is really great tutorial sir, Thank you so much @Twilio

[@aumaritsakhon129]

Hello Can we make search in a sheet on php?

[@JaehoonMe]

Thank you very much, you helped me a lot!

[@twilio]

Glad I could help!

[@kurdtpage]

Why are you using "print"? Why not "echo"?

[@twilio]

I did use echo. First I formatted the string with sprintf (www.php.net/manual/en/function.sprintf.php) and then used echo.

[@przemyslawidzczak5268]

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

[@twilio]

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.

[@faisalzubair5065]

Great video but how can we do that with C#?

[@subjectfrank]

Hello, Where can i find credentials.json file?

[@rachidimohamed6640]

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

[@joekustek2623]

Composer can not find files any idea's?

[@merajali938]

@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

[@elierakotonomenjanahary2150]

Thanks. But i got error : google-api-php-client.ERROR: Service parameter missing {"service":"sheets","resource":"values","method":"get","p arameter":"spreadsheetId"} []

[@amitpathry3118]

any link to the written code?

[@mariavillanueva9576]

How do you implement a workaround for 'too many request' with error code 429 aside from upgrading the account?

[@twilio]

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.

[@mariavillanueva9576]

@@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

[@diegolopez9851]

i'm try to use it on a cpanel hosted server but it does not work. why?

[@macare-engineering8379]

I wanna know is the credentials service account is a lifetime or would be expired?

[@twilio]

As far as I know the service account does not expire.

[@macare-engineering8379]

@@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?

[@twilio]

@@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.

[@GetTechidea]

how can i create a new google sheet as i want to export table data as google sheet ?

[@twilio]

I think you will need to use the Google Drive API to do this.

[@ottomanempire3746]

you should give a link to your code you have used

[@XavierLanglois]

perfect. thanks ! I use it to generate ad scripts for my websites

[@juansalvadorrodriguezluna9580]

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]

Hit me up on Twitter @GeeH and I'll give you some help ^G

[@hanibioud]

Dude, i'm getting Warning: count(): Parameter must be an array or an object that implements Countable..

[@micaelbao]

Why does my quickstart fail? Google's document is worse than instructions from users? you are great, thank you so much

[@ased4u]

Really good video. Thank you!

[@walney2008]

download script ? tnhks im from Brasil,

[@supplier409jualharga3]

very nice. thank you

[@anhnampham3929]

how to delete rows or columns

[@SkyWalker-v1m]

I wasn't able to get further...needs OAuth 2.0

[@ashishbansal2867]

how to add comments into cell. no code found

[@AliRaza77]

I think google should hire you for the documentation and product's demo engineer.

[@nicolaspistillo6322]

where i con found the credentials.json?

[@twilio]

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.

[@JickLibot]

Thank you very much, you saved my day!

[@mikegonzalez4092]

man youre my hero :D thanks!

[@twilio]

Glad we could help!

[@newborn7850]

is google API free?

[@koala1976]

youre the best thank you...

[@datbui8995]

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

[@pablodeoliveira5142]

Life saver! :D Thank you so much for the video

[@alexorochiCC]

Thanks, this is so good. You won a new suscriptor

[@twilio]

Thanks for watching and for the sub!

[@ComputerScienceMaster]

Muito bom tutorial... adorei.

[@kumardeepak3380]

I am getting exception error, please help me

[@twilio]

Hi! Need more info than that to be able to help. What’s the error message you’re getting?

[@PaulWhiskey]

Thanks you so much!! Is excelent, thank you

[@Abphaiboon]

This video helped alot! thanks!

[@twilio]

We're glad you found it useful, thanks for watching!

[@honoremwiseneza2970]

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" }

[@honoremwiseneza2970]

kindly guide me I am blocked

[@twilio]

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?

[@honoremwiseneza2970]

@@twilio $response =$service->spreadsheets_values->get($spreadsheetId, $range);

[@kendouciabdelaliilyas]

@@honoremwiseneza2970 Please did you find the solution ?

[@honoremwiseneza2067]

@@kendouciabdelaliilyas No I didn't

[@geeksy2278]

Awesome thank you!!!

[@twilio]

You're welcome, thanks for watching!

[@franciscoroa6876]

this is awesome man ! thanks!

[@Priyankmotivaras]

Thanks ,Worked for me

[@atnewsnet]

github?

[@zahirzohair1372]

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

[@nomadtrails]

This is out of date. Service accounts don't have json exports evidently.

[@MrSzegerege]

Damn on localhost it works perfect, on prod i get "call to undefined method GoogleClient::setAuthConfig"

[@allansetsuki]

Thank you so much

[@twilio]

You’re welcome!

[@Shkur777]

More easy than in 2010