Bulk update rows

[ai.witu.world]

Hi there! I’m really excited about working with MAKE and I’ve been diving into it. I’m still fairly new, so I have a very basic question, and if there’s an issue with the scenario itself due to my lack of experience, please let me know.

Currently, I’m pulling Instagram Reels data through Apify. However, the data doesn’t include follower information, so I’m trying to run an additional API to collect follower data for the entries that were initially gathered.

In the first step, I used “Bulk add rows” to gather all the data except for the followers in column D of the sheet. After that, I plan to connect the follower collection API in the same way as the previous steps, starting with “Get Range Value.”

The initial data collection gave me the IDs of 9 creators and a total of 32 pieces of content. Now, in the second step, I want to collect the current follower count for these 9 creators and input it into the empty “followers” column on the row that corresponds to their ID.

Through the “Apify - Get Dataset Items,” I was able to obtain 9 bundles and used the “Array Aggregator” to group them by Username, so that the follower counts would be placed into the empty D column (column 4).

Here’s the issue: I’m completely stuck on how to proceed with the bulk update row process.

I’ve tried a bunch of different things over the past two days. It feels like I’m learning and making progress, but it’s so frustrating to keep failing.

Currently, the D column in my sheet is left empty for followers, and column N has the usernames. Out of the 32 rows, the 9 usernames are randomly distributed across them.

I’m really in need of help, so please, if you can assist, I’d really appreciate it!

[samliew]

Welcome to the Make community!

If you use “Group By” field, you’ll need a second Array Aggregator if you want to Bulk Update Rows.

This is because “Group By” can produce more than one bundle - one for each group.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[ai.witu.world]

I’m really sorry to bring this up.

You explained it in such a straightforward way, but I feel a bit discouraged that I couldn’t manage something that seemed so simple.

I’ve been trying to figure this out for two days now, and I’m sorry that I still can’t get this basic part working. Could I ask for a slightly more detailed explanation of the flow?

Please forget my previous explanations; to restate it simply:

• I loaded a Google Sheet,

• Set various options to specify a range,

• Found a total of 33 rows, which are divided into 9 variations.

All 33 rows for these 9 variations have an empty value in column D, and I obtained the values to fill them using Apify. For example, among the 9 variations, variation A has 10,000 followers, variation B has 20,000 followers, and so on for all of them.

Now, I need to use “Bulk update rows” to put these values into each corresponding cell.

I tried all sorts of approaches: bundling keys and arrays together (not sure if that was the right direction), trying other methods besides “bulk update rows,” and so on—but everything failed.

If you could point me in the right direction, I’d really like to succeed this time.

I know I have a lot to learn, and I’m sorry for being a burden. You previously mentioned that I might need an additional “array aggregator,” but it seemed I still didn’t have enough information to make it work.

I’m really sorry, but if you don’t mind, could you guide me through this again? If it’s okay, I’d even like to extract the blueprint for some step-by-step guidance.

Thank you very much. @samliew