Question

Get cell value from Excel

  • 15 March 2024
  • 1 reply
  • 44 views

Hi, apologies that this may be fairly straightforward but I am struggling to find a solution.

 

I have a Zap, that updates the 2nd row values for columns 1 and 2 based on a new form submission. The Excel sheet then has a formula to calculate the amount in USD based on the value and currency inputted from the form. The value is presented in Row 2, Column 3. 

 

All I would like to do is output the value of Row 2, Column 3 so that I code feed that into Code by Zapier. Could anyone advise on how to do this?

 

I can do this quite easily using Google Sheets - get many rows action. But I can’t seem to find this functionality for Excel.

 

Thank you in advance!

 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @pjackson 

Unfortunately, the Excel Zap app has less/limited options compared to using GSheets in Zaps.