Is it possible to have an automation which is triggered only when a hardware switch (wall switch connected to my fibaro double switch) is used to turn the light on and not when the light is turned on by some other automation?
Yes but you will have to store the fact that an automation changed the switch yourself using (for example) an input boolean or mqtt value. You can then use this as a condition in the automation you only want to trigger on manual switch events.