Numbering new excel row + updating specific ones

Question

Hello everyone,
I’m currently trying to create an excel file with different triggers and scenarios. I’m importing form responses from Slack workflows to Excel and I would also like to set a trigger so when someone reacts to that message with a specific emote, it will automatically update a cell in the row of that particular response.

I thought that as an identifier, I would use numbering of every response but I’m kinda stuck in here. Do you have any idea how could I add a numbering (1,2,3,etc.) to a column once every new row is created?

Or if you have any ideas how could I approach my situation with automatically updating a specific cell it would also help me out.

Thank you in advance! 🙂

Danvers · Accepted Answer

Hi @freshuh!Could I ask which Zapier integration are you using as the trigger for your Zap? And are there any fields in the form that are unique to that particular response eg email?I’m thinking along the lines of creating a lookup table in a different sheet in the same Excel workbook. Something that has a unique value that both the form response trigger and the reaction trigger have in common.For example, if you get a timestamp of when the form is posted in Slack, you could create something like this:Zap 1Form response posted in SlackAdd new row in sheet 1In sheet 2 add the timestamp (ts) field in one column and the row ID of the row created in the other.Zap 2New reaction added in SlackFind Row - search for the timestamp using the message_ts fieldUpdate row - use the row ID found in the previous step to tell the Zap which row to update.Do you think something like that might work in your case?

freshuh · Answer

Hi@freshuh!Could I ask which Zapier integration are you using as the trigger for your Zap? And are there any fields in the form that are unique to that particular response eg email?I’m thinking along the lines of creating a lookup table in a different sheet in the same Excel workbook. Something that has a unique value that both the form response trigger and the reaction trigger have in common.For example, if you get a timestamp of when the form is posted in Slack, you could create something like this:Zap 1Form response posted in SlackAdd new row in sheet 1In sheet 2 add the timestamp (ts) field in one column and the row ID of the row created in the other.Zap 2New reaction added in SlackFind Row - search for the timestamp using the message_ts fieldUpdate row - use the row ID found in the previous step to tell the Zap which row to update.Do you think something like that might work in your case?Hi @DanversThanks for jumping into this.I’m using Slack Workflows as a trigger and then More Steps by Zapier to send it to an excel sheet.This is great idea and I wanted to do it similar way but unfortunately there isn’t any unique field that I can use as an identifier, that’s why I was thinking with automatic numbering rows.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded