Okay, a lot of unpack here. As long as you have a complete Google Drive backup, all of your automations are present. When you download the Google Drive backup onto your Desktop computer, double click it (should have something like WinRar to open the compressed file. Then scroll down and find .\homeassistant.tar.gz which you should also double click to open. Open the data folder and all of your /config from the backup are right there including your automations.yaml and configuration.yaml. Although you can transfer these files directly to your HA instance by using Samba Share add-on installed on your HA, and open your current HA files from your Explorer and copy these in (and restart), you should be careful doing this as it can cause errors. And without tinkering with the CLI interface (controlling your HA hub by connecting a monitor and keyboard to it - like DOS but still very different commands) it can be difficult to do proper restarts, reboots, etc outside of HA.