Hi
I’m trying to work out how to hash (ie encrypt) data in 2 columns in a Google Sheet - ie name and email address.
Is there a way to do it with a zap?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31050 replies
Can you clarify more about what you’re trying to do in terms of order of operations?
- Beginner
- 2 replies
Hi Troy.
I have a sheet with 148 rows of survey data. Columns include name, email, phone and scores on various characteristics
I would like to encrypt the data in 3 columns only - ie to replace the name, email and phone with unique numbers - leaving all the other data in each row alone - so that
- we can track changes in scores by name
- be able to decrypt back if needed
In terms of order of operations, I’d guess it would be:
open sheet
row by row
convert data in each of 3 columns to a hash
close
(or create 3 new cols and put the hashes in new cells)
Does that help?
- Beginner
- 2 replies
Er, I don’t know. Whatever is appropriate.
I just googled it and saw “at least AES 256” - if that makes sense
+8- Zapier Staff
- 1366 replies
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.