I’m curious as to what the GS team will recommend, but all of that should be possible through the API.
https://api2-us-west-2.insided.com/docs/community/#tag/Ideas
It’ll take a bit of effort setting it up, but let’s say you can export your current ideas to a spreadsheet, you could do a one-time bulk upload that creates them all using the Submit Idea operation.
And you could do something similar to apply the votes you already have.
Each will take some vlookup type work to find the corresponding userIds for the users who submitted/voted.
And yes, you can vote on someone’s behalf via that API as well.
I use Zapier for a lot things that I want to do through the API, setting up simple automations for ad hoc use cases like this. If I needed this, I’d build
- Spreadsheet
- UserId or email of user I need to vote on behalf of
- Id of the idea they need to vote for
- Zapier automation
- Trigger = New spreadsheet row (available for google sheets, likely also excel)
- Action = API Request that runs this Vote Idea operation
Tip: Often times I’ll have email handy and not the user’s community userId. So I build a lot of my Zaps to just provide the email address. Then I add a middle step using the Find a User action pre-built in Zapier (also an API operation). It returns their userId so I can use in the API Request step, saving me the many clicks it would take to go into Control > User Overview > Search > Find the userId via their profile, etc.