String(307) 'The story follows Carol Danvers as she becomes one of the universe’s most powerful heroes when Earth is caught in the middle of a galactic war between two alien races. String(98) 'A boy is given the ability to become an adult superhero in times of need with a single magic word.' We have to share this document with the previously generated service account email (we set Editor permissions to allow the update of the sheets): In this tutorial, I use a collection of movies:Ī spreadsheet can contain several sheets this one has a single sheet named Sheet1. The bit tedious configuration part is over! Create and Share a Google Sheets We can now download the key file in local and rename it to credentials.json. We edit the service account to create a new key, using the json type: We need to create a service account (the generated email will be useful later 💡): We now create credentials, in this tutorial, we'll use Application data access: Once enabled, we can configure the service: Open the Google Cloud Console and create a new project:Ĭlick on Enable APIs and Service, search for Sheets API, enable the service: Create a Google Project and Configure Sheets API įirst, let's configure a new Google Console project to enable Sheets API. The whole code and examples are available in a GitHub repository it comes packaged as a simple Symfony project and provides a Docker image. Let's learn how to manipulate Google Sheets using the PHP API Client. Google Sheets is a very used online spreadsheets system allowing real-time collaboration on the data.

Php code writer