I’m thinking of using a Pub/Sub topic. There are third-party SMS gateway services that allows you to configure a webhook that triggers when an SMS is received. This webhook can then send the data to a Pub/Sub topic. Then create a Cloud Run service that subscribes to the Pub/Sub topic. This service will receive the SMS data and then insert it into a BigQuery table. Let me know if this works.