Not sure whether this is the correct outlet for this question but here goes. Currently, my company’s connection to airtable has to be refreshed manually when we are updating our dashboards. However, we are looking to speed this up by periodically running the flow so that the dashboard can be updated automatically.
As of now, what ive researched is to use pyairtable to extract the data and clean it within python first and then use a seperate automation script (pythonanywhere maybe) to run this extract periodically.
My question is: Is there a better way to go about this? or is this really the fastest way to connect it？
