Update google sheets with data received from an Apify actor run

Questions
1

Describe the problem/error/question

I’m reading the LinkedIn URL from a row in a google sheet and passing it to an Apify actor, which takes this URL and returns the LinkedIn posts made by that person. I’m stuck at trying to parse this data and update the original sheet with this data under a column called Text. As you can see from the Apify dataset, the posts include original posts made by the author along with reposts. It also includes posts by those who are not in the list.

How do I select the data that only belongs to the individual in the row, combine all the posts, and then add them back to the column (named “text”) in the sheet?

Please share your workflow

The workflow is available here.

The sheet from which the LI URLs are being read is here. This is the same sheet that I would like to update the data to.

Share the output returned by the last node

The output of the Apify actor run is available here.

Information on your n8n setup

  • n8n version: 1.109.2
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Debian 13
2

Hey, check this out and feel free to mark as Solution if it helps you:

  • loops 1 by 1 all the profiles
  • combines the posts into a text field
  • updates the row in the sheet
1 Like
3

Thanks a ton! This was very helpful.