ERPs be setup to send scheduled/structured reports to snow over email with standard subject for snow

[Nagoor Basha 1]

ERP systems where data cannot be fetched centrally, can those ERPs be setup to send scheduled/structured reports to snow over email with standard subject for snow to process them (upload the info in a table)

How we can load data from email attachement that is sends to servicenow which translates and tranform into the servicenow Desire table

[Mark Manders]

Do you want them to be send to Snow or to ServiceNow? These are two completely different platforms, but assuming you mean ServiceNow: ServiceNow is capable to import datasheets into the system. 

Your question about 'can those ERPs be setup to send scheduled/structured reports' is not something we can answer because we don't know which ERPs you are using and what they can or can't do.

If they can, just create an inbound email flow to capture the incoming email, based on subject and from that, create a data source to which you copy the attachment and select the Import Set Table and correct info on their. A transform map can then take care of transforming the data. 
Triggering the transform can be done with a BR on the import set table.