Hi!
I'm using Hexomatic in combination with Google Sheets. In Hexomatic I've setup a daily scraper that has to export the data to a Google Sheet.
I noticed Hexomatic isn't very reliable in terms of exporting to Google Sheets, and their team is working on it. In the meantime it's possible to export the data using a webhook. Pabbly succesfully retrieves all of the data, but I don't know how to make multiple Google Sheets from all of the data from the Webhook.
The webhook contains data for 50 rows and per row 5 colums of data. So there are a minimum of 250 data points form the webhook.
Does anyone know how to simple create 50 rows with 5 colums per row with the data from the webhook?
Thanks!
I'm using Hexomatic in combination with Google Sheets. In Hexomatic I've setup a daily scraper that has to export the data to a Google Sheet.
I noticed Hexomatic isn't very reliable in terms of exporting to Google Sheets, and their team is working on it. In the meantime it's possible to export the data using a webhook. Pabbly succesfully retrieves all of the data, but I don't know how to make multiple Google Sheets from all of the data from the Webhook.
The webhook contains data for 50 rows and per row 5 colums of data. So there are a minimum of 250 data points form the webhook.
Does anyone know how to simple create 50 rows with 5 colums per row with the data from the webhook?
Thanks!