Crawler is built through python and runs from a Linux server. The crawler is set to run and scrap data 2 times in 1 day. Crawler is meant to autoupdate data to a googlesheet. The googlesheet has 2 sheets. Sheet1 updates as the crawler run. And when the sheet1 finished updating completely, all data is copy-pasted to sheet2 straightaway after. The issue is either the googlesheet is not auto-updating, or the Python script is not starting automatically. Each time i am having to run the script manually.
I need assistance with setting up an API call from the following into Google Sheets. Deputy Daily wage costs Hourly wages vs Revenue Revel - Net Revenue Category break on sales Total Units sold top 5 performing products, and bottom 5 performing products I have some code already written with the API calls already setup but they need to be streamlined and better optimised.