In general, the actions available in automations are limited to those which impact the database where the automation is stored, but this does mean that if that database is related to other databases, you can affect (create/link/update) entities in those related databases, irrespective of the spaces they are in.
If you want some help on a specific automation you would like to implement, just let us know.