Delete records automatically which are older than 3 months? Is that possible?
One way to do this would be to create a Report that runs periodically. Assuming you stored the record creation date in the record, you could detect which records should be deleted based on their creation date. Your Report could invoke a webhook that used the
AppSheet API to delete the expired records.
@Etwo_Cargo As @Philip_Garrett_Appsh suggested you can use Scheduled Reports to invoke a webhook to AppSheet API which will need a Pro Plan subscription. If that’s not the case, then you can write a time-triggered script to your gSheet which will delete the old data.