Get scraped data from Google Sheets

[Johnik]

Hi.

I'm scraping data into google sheets with the IMPORTXML function.
I want to use that data and send to other services with Pabbly.
Problem is that when I get the Google Sheet in Pabbly it returns empty cells. Guessing that is because the scraping reloads every time you open the sheet and it's not done yet when Pabbly access it.

Is there a way to let the sheet load for a minute before getting the data?

Thank you!

 

[PabblyMember4]

Hey @Johnik

Could you please share the workflow name to check the issue? Also, please share the short video for the issue for better understanding.

 

[Johnik]

The question i pretty simple...
Is there a way to wait a minute or two before it fetch the data from Google Sheets?
Open the sheet / wait 2 minutes / Get data

 

[PabblyMember4]

Hey @Johnik

You can add a delay module by Pabbly and wait for 2 mins before entering the data in the sheet. Please check the below video for delay module.

 

[Johnik]

Hey @Johnik

You can add a delay module by Pabbly and wait for 2 mins before entering the data in the sheet. Please check the below video for delay module.

Thank you Kunal. But the delay module is activated either before accessing the google sheet or after getting the data. I need something inbetween. But i guess I need to find a way to "hardcode" the data before fetching it.

 

[PabblyMember4]

Hey @Johnik

Please let me know if you are using any function inside the Google Sheets. If yes, then this scenario is not possible you should not use any type of formula in the Google Sheets as it will create issues in fetching the data.