google-sheets - Zapier: Update google spread sheet row

Question

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.

Earlier Approach:

sheet column => Total => Lookup value was 'Last 7 Days'

What I want now:

sheet column => Total => Lookup value will be like 'Sunday, July 19, 2020'

And each day we will be able to see new value in each row of Total column.

So how can I handle this in Zapier?

Google Sheet:

Zap Steps:

Zap Sheet Lookup Detail:

标签： google-sheetszapier