nidup / manipulate-google-sheets-api-in-php

Code examples for the tutorial How to Use Google Sheets API in PHP?

Hi there 👋

I'm nidup, co-founder and chief product officer at Akeneo during the day ☀, Indiehacker during the night 🌖, I love creating products 😍

• 💬 I love discussing product, technology, team work, and business
• 📝 I write articles (from time to time) on my blog
• 💻 I love open source, and I enjoy sharing publically what I learn
• 📚 I like to read, leadership books during the day, Sci-Fi novels during the night
• 🎮 I like to practice gam jams, you can find my games in my repos or play them on ldjam.com
• ✨ I'm a bit addicted to emojis, I use them far too much
• 🐦 You can reach me on Twitter @duponico
• 🏗 You can reach me on IndieHacker @nidup

manipulate-google-sheets-api-in-php's Issues

Get the values and their cell range for each one for updating one row later

Hi Nico
Not an issue but a question:

I call $response->get_values(); and all works fine, but I'd like to get the cell range for the values in specific column

Let's say I'd like to modify a row, right? I have a column with people's SSN (social security number) which is a univocal data.
I want to modify a person's name/surname for a specific SSN, but I don't know where is that row located in the Spreadsheet...
Therefore I must search this SSN value before modifying it and get its location in the SpreadSheet, eg Sheet1!D18

Is there a way to search in the SpreadSheet and get the cell for the specific value searched? Or to get all the values with their corresponding cell range/location ...?

Thanks a lot in advance,

PS: Excellent article/post. Very detailed/useful
https://www.nidup.io/blog/manipulate-google-sheets-in-php-with-api