I am trying to fin Zapier to do a task for me with getting information from browse.ai and insert to google spreadsheets which I manage to do. BUT.
I also want to add an incremental number on the same row. Is that possible?
In text:
1. Get my Tennis Ranking from Browse.ai
2. Create and insert it on a new row (column in a Google Spreadsheet.
This 2 steps I manage, here comes the part I dont manage:
3. Insert incremental number (week number of the year) in column A on that new row. (Should be previous week +1)
Example:
Ranking number 64 is inserted in column B on the last created new row.
Previous row shows previous week number 5 so on the new row column A should be created the number 6.
Next week maybe I have ranking 59, that should be inserted on the last new row.
The week number 7 shall be inserted in Column A on the same row.
Can anyone help me with this issue in adding week-number to a newly created row in Google Spreadsheets.
Thank you for a great tool.