For a no-code/low-code way of doing this, you can use Make’s Google Analytics 4 integrations.
There is a small learning curve with Make, which is why I created this basic navigation video to help. I also provide the links to a few other Make training resources there as well.
If you know how to code, you can use Airtable's scripting extension to run your own custom JavaScript code. Airtable’s automations also have a “run script” action.