Enter data to a specific cell in Google Sheet based on both column and row lookup

Hi @adamstanley 

Can you provide screenshots of how your GSheet is configured that you are trying to use in the Lookup step of the Zap?

Can you outline a specific example and the desired output of the Zap?

Hi @Troy Tessalone ,

Thanks for getting in touch. Please see GSheet screenshot here:

Essentially, the I have a measurable on each row, and each week I want to enter the result in the current week commencing column.

Set up of Zap:

Every Sunday, run the task (fine)

Look up values from another sheet (fine)

I think need to find the correct cell reference and find a way to update the value which is where I’m struggling. For example, for Measurable 1 the cell to enter the data would be H4.

I can see there is a way to lookup by Row and Updated Row, but can’t find a way to lookup and update a specific cell based on row AND column lookup. 

Any help or suggestions much appreciated!

Thanks

Adam

Hi @adamstanley 

You may want to consider structuring your GSheet differently, then either employing pivot tables or formulas to get the data to update as you desire, since doing what you’ve described of dynamically populating a specific cell in a row/column isn’t best served for being done via a Zap.

Check out this help article about how GSheets need to be structured to be used in Zaps:

https://zapier.com/help/doc/how-to-set-up-your-google-spreadsheet-to-work-with-zapier

• The first row must have titles for any column headers you want to be able to see in your Zap.
• The second row must have content for any columns you want to be able to see in your Zap.
• There can be no completely blank rows before the end of your spreadsheet.

Thanks Troy, appreciate it.

The difficulty with a Pivot or formulas is I’m bring in data from a variety of sheets, which all updates dynamically which is why I want to create a ‘timestamp’ each week.

Thanks for the link above - are you aware of any way to target a specific cell to update?

Thanks

Adam

Thanks Troy!

Hi @adamstanley 


If you are still struggling with this, I believe I can help you build a custom integration with Google Sheets that will work for you! 

Please send me a direct message if you’re interested! 

In the end, I ended up creating a Google script to achieve the desired result rather than using Zapier.