Can't use "New and Updated Spreadsheet Row" with date in spreadsheet

[ldodds]

Expected Behaviour

When I'm triggering metric submissions using the "New or Updated Spreadsheet Row" option, I sometimes want to be able to use a date specified in the spreadsheet. E.g. the day that the data was collected.

The Zapier lets me choose a cell from which it'll read my date, rather than the default of "now"

Current Behaviour (for problems)

The integration works the first time, but then fails because Bothan rejects updates to metrics.

This makes it impossible(?) to use the "New and Updated" functionality without relying on "now" as the timestamp. That's not always desirable, but can' be worked around by keeping the timestamped data separately in the spreadsheet.

Steps to Reproduce (for problems)

1. Create a new Zap, add a trigger for New or Updated Row from Google Sheet
2. In the Bothan template, select column for metric and a column for the date
3. The Zap should work
4. Edit the date, then manually re-run the Zap. You should get an error from Bothan.

Your Environment

Include as many relevant details about the environment you experienced the bug in - this will help us resolve the bug more expediently

• Environment name and version (e.g. Chrome 39, node.js 5.4):
• Operating System and version (desktop or mobile):