Can I use the automation API within a resource to query if the resource is being invoked from a Create or Update?

I don’t know what you mean by “within a resource” but if you invoke your Pulumi update via automation api than you can subscribe to engine events so you can watch for create or update events against specific resources