title: Zapier: Update google spread sheet row
body: <p>I have tried to updated google sheet row by giving a value to look up and I got an updated row in google sheet. But now I have to update row using dynamic value.</p>
  <p>Earlier Approach:</p>
  <p>sheet column =&gt; Total =&gt; Lookup value was 'Last 7 Days'</p>
  <p>What I want now:</p>
  <p>sheet column =&gt; Total =&gt; Lookup value will be like 'Sunday, July 19, 2020'</p>
  <p>And each day we will be able to see new value in each row of Total column.</p>
  <p><strong>So how can I handle this in Zapier?</strong></p>
  <p>Google Sheet:
  <a href="https://i.stack.imgur.com/gbhKO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gbhKO.png" alt="enter image description here" /></a></p>
  <p>Zap Steps:
  <a href="https://i.stack.imgur.com/5Jsso.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5Jsso.png" alt="enter image description here" /></a></p>
  <p>Zap Sheet Lookup Detail:
  <a href="https://i.stack.imgur.com/rbnsn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rbnsn.png" alt="enter image description here" /></a></p>