Skip to main content
Solved

How to convert bulk conversations in a category to Product Ideas

D
  • Deja
  • Contributor ⭐️⭐️⭐️
  • 12 replies



Hello, I have nearly 400 posts in a category that I want to convert all of them to the Product Ideation module. 

I was told that I can do this via API, can someone show me step by step on how to do this?

Otherwise, I’d have to manually do this one by one

 


Thanks1!

Best answer by DannyPancratz

  1. ​​​​ Put your data in a google sheet (you can probably do this with Excel 365 too)
    1. It needs to have the topic Id
  2. Build a Zapier automation (that you’ll run just 1 time and then can shut off) 
    1. Trigger: New or updated spreadsheet row (Google sheets)
    2. Action: API request (beta) (Gainsight CC)
      1. This pre-built action already authenticates via your Gainsight CC-Zapier connection 
      2. You have it run this POST operation for convert conversation to Idea
        1. Id data from the trigger
        2. ModeratorId is your Id as an admin
  3. Publish the Zap, turn it on
  4. Use the Transfer existing data option in Zapier to make the Zap run the for each row in your spreadsheet
    1. It will use 400 zap runs/actions to process the 400 rows in your spreadsheet
    2. It will take a few minutes
  5. Turn it off when your done so that it doesn’t accidentally run when you make edits to the sheet
    1. Or you could leave it on and you have a prebuilt automation for any time you need to convert them, but you can also more easily do one-off conversations in Control
View original
Did you find this topic helpful?

5 replies

DannyPancratz
Forum|alt.badge.img+7
  • DannyPancratz
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 942 replies
  • August 22, 2024

Do you use Zapier or something else for API stuff? 

D
  • Deja
  • Author
  • Contributor ⭐️⭐️⭐️
  • 12 replies
  • August 22, 2024

I do have a Zapier account, I don’t have experience with API

DannyPancratz
Forum|alt.badge.img+7
  • DannyPancratz
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 942 replies
  • August 22, 2024

I’ll send you a message so that you can schedule time with me if you want help doing this. But how to do it in my next reply. 

DannyPancratz
Forum|alt.badge.img+7
  • DannyPancratz
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 942 replies
  • Answer
  • August 22, 2024
  1. ​​​​ Put your data in a google sheet (you can probably do this with Excel 365 too)
    1. It needs to have the topic Id
  2. Build a Zapier automation (that you’ll run just 1 time and then can shut off) 
    1. Trigger: New or updated spreadsheet row (Google sheets)
    2. Action: API request (beta) (Gainsight CC)
      1. This pre-built action already authenticates via your Gainsight CC-Zapier connection 
      2. You have it run this POST operation for convert conversation to Idea
        1. Id data from the trigger
        2. ModeratorId is your Id as an admin
  3. Publish the Zap, turn it on
  4. Use the Transfer existing data option in Zapier to make the Zap run the for each row in your spreadsheet
    1. It will use 400 zap runs/actions to process the 400 rows in your spreadsheet
    2. It will take a few minutes
  5. Turn it off when your done so that it doesn’t accidentally run when you make edits to the sheet
    1. Or you could leave it on and you have a prebuilt automation for any time you need to convert them, but you can also more easily do one-off conversations in Control
D
  • Deja
  • Author
  • Contributor ⭐️⭐️⭐️
  • 12 replies
  • August 28, 2024

This was perfect, thank you @DannyPancratz !!

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings