Hey there ​@Pitel, welcome to the Community! 

I had a quick look and the MyOTP.App has a Send OTP action that you could potentially use to generate the one-time password and send it to the users via SMS.

Would that work for your needs?

Hey ​@SamB 

Sorry for the late reply.  No, sending SMS won't work for me, and I finally fou d out rhat we cannot use onetimesecret api as we can't create an account for that app.

I'm actually stuck again for another issue I'm experiencing. I have a spreadsheet with a column named titles, and I want to have some files links (files already copied in my zap) embedded into titles already existing in that column. When I add a step to lookup spreadsheet row, I pick the spreadsheet dynamically by its ID, but in the worksheet field, I can find the sheet but its id is zeroed! Once I add it and add the value column and the row field title, everything gets removed and I need to select again the worksheet, but I'm not able to test. I already checked the spreadsheet id, the worksheet title, I even tried with manual selection and it worked so the problem must the gant to make it dynamic. Any suggestions on what I could have done wrong?

Thank you so much for your help!

I’m sorry to hear that, ​@Pitel. What is the one-time password giving people access to exactly? Is it giving them access to a spreadsheet or something else?

Asking as I know Zapier Interfaces has the ability to send one time passcodes to access an interface—you can learn more about that here: Change access permissions in Zapier Interfaces. Just wondering if whatever you’re giving folks access to could be added to the interface some how, which could mean that you then wouldn’t need to manually record and presumably send the codes out to people. Do you think that approach could work?

With the other issue you’re running into the ID of the first worksheet in a spreadsheet is always 0 so that’s to be expected. But I’m not 100% sure why everything is being removed once you add a value.

Do you have the same Zap open in any other browser windows/tabs, or could another member of your team be looking at the Zap at the same time? I’ve seen strange behavior myself where changes I’d just made were undone, when myself and a colleague both had the same Zap open. Do you think that could be the case?

The one-time password generates a temporary link, valid for a single click, to retrieve the user's credentials (username and password). This link expires after the first click, providing a single opportunity to access the credentials. If users fail to use the link, they must contact me for manual creation of another access link. This process adheres to our company's user credential security standards.

Regarding the other issue, I'm unsure why it's being removed. I've confirmed that it's not open in any other browser, and no one is accessing the Zap. I'm currently stuck on this step.

Ah I see! Thanks for clarifying the one-time password process you’re currently using ​@Pitel—much appreciated! 

I did some further digging and it looks like Onetime Secret have a public API endpoint that would allow you to generate the onetime use links: https://docs.onetimesecret.com/docs/rest-api/create-secrets. So you could potentially use a POST (Webhooks by Zapier) action to make a request to that API endpoint to generate the link rather than having to do it manually. Then you could use an Update Spreadsheet Row action to add it back into the Google Sheets spreadsheet. If you’ve not used Webhooks actions in Zaps before I’d recommend checking out our Send webhooks in Zaps guide to get started.

With that other issue of the selected values being removed, it turns out other folks ran into that too after you flagged it here. A bug was filed by our Support team and has since been fixed, so the values should no longer be being removed! 

Please do keep me posted on how you get on with setting up the Webhooks action, happy to assist if you get stuck on that at all. 

Hi SamB,

Thank you for your assistance.

I'm still encountering an issue with One-Time Secret. To use the One-Time Secret service, an account is required. However, after creating an account, I'm not being logged in, although the option to create a link is still presented. This behavior is unexpected and I'm unable to determine the cause.

I appreciate you resolving the issue with the removal of selected values.

I'm now facing a problem with the Formatter step. When attempting to replace the encoded space character ('%20') with a standard space, the replacement is not working as expected.

For example:

https:// client.sharepoint.com/:f:/r/sites/Example/Shared%20Documents/implementation%20team?etcc…

The desired output is:

/sites/Example/Shared Documents/implementation team (with spaces between 'Shared Documents' and 'implementation team').

I've tried entering a space in the 'Replace' field, but Zapier doesn't seem to recognize it. Could you suggest a workaround or identify if I'm doing something incorrectly?"

Thank you so much!

Sorry for the delay in my reply here, ​@Pitel. 

Did you get a verification email from OneTime Secret after creating your account? Just wondering if it could be that you need to click a link in that email to verify the account before you will be able to log into it and generate the necessary API Key for the Webhooks action.  It’s possible that their email may have gone into your Spam/Junk folder so I’d recommend double-checking there too just in case.

With the Formatter issue could you share a screenshot of the set up of the Formatter action so we can get a better idea of what might be preventing it from working properly? Make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing—you can use a tool like Zappy for that.

Looking forward to hearing from you!