Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Numbering new excel row + updating specific ones

  • August 23, 2022
  • 3 replies
  • 272 views
F

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! 🙂

Best answer by Danvers

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 1

  1. Form response posted in Slack
  2. Add new row in sheet 1
  3. In sheet 2 add the timestamp (ts) field in one column and the row ID of the row created in the other. 

 

Zap 2

  1. New reaction added in Slack
  2. Find Row - search for the timestamp using the message_ts field
  3. Update 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? 

Matej Laucik
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • Answer
  • August 23, 2022

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 1

  1. Form response posted in Slack
  2. Add new row in sheet 1
  3. In sheet 2 add the timestamp (ts) field in one column and the row ID of the row created in the other. 

 

Zap 2

  1. New reaction added in Slack
  2. Find Row - search for the timestamp using the message_ts field
  3. Update 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? 

F
  • freshuhBeginner
  • Author
  • Beginner
  • 2 replies
  • August 24, 2022

 

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 1

  1. Form response posted in Slack
  2. Add new row in sheet 1
  3. In sheet 2 add the timestamp (ts) field in one column and the row ID of the row created in the other. 

 

Zap 2

  1. New reaction added in Slack
  2. Find Row - search for the timestamp using the message_ts field
  3. Update 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 @Danvers 

Thanks 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. 

 

Matej Laucik
M
Forum|alt.badge.img+5
  • MichelleSZapier Staff
  • Zapier Staff
  • 54 replies
  • August 29, 2022

Hey, @freshuh !

Thanks for that additional info. If there’s no unique identifier you can use, you can definitely count up using the Storage app. Here’s instructions: https://zapier.com/help/create/storage-and-digests/storage-examples-in-zaps#zap-1-increment

I hope this points you in the right direction! Please let me know if you have any other questions.

Terms & ConditionsAccessibility statement