US 12,443,566 B2
Email-based data transfer and synchronization
Chuan Ji, Sunnyvale, CA (US); Evan Purcell, San Francisco, CA (US); Yian Cheng, Fremont, CA (US); and Manan Nayak, Kensington, CA (US)
Assigned to Formagrid Inc, San Francisco, CA (US)
Filed by Formagrid Inc, San Francisco, CA (US)
Filed on Aug. 8, 2022, as Appl. No. 17/883,533.
Claims priority of provisional application 63/238,010, filed on Aug. 27, 2021.
Prior Publication US 2023/0078600 A1, Mar. 16, 2023
Int. Cl. G06F 16/178 (2019.01); H04L 51/046 (2022.01)
CPC G06F 16/178 (2019.01) [H04L 51/046 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for email synchronization of a data table, the computer-implemented method comprising:
receiving, by a server comprising a processor, a request to synchronize data with a data table, wherein the data table includes records, each record of the records in the data table having a respective record identifier and one or more attributes;
generating, by the server, a table email address corresponding to the data table, wherein the table email address is a new email address that uniquely identifies the data table;
receiving, by the server, an email addressed to the table email address, wherein the email comprises a data file including one or more corresponding updated records to update the records in the data table corresponding to the table email address, each updated record of the one or more corresponding updated records comprising a respective record identifier of the respective record identifiers and one or more updated attributes;
verifying, by the server, that the email is from an email address that has access permission to the data table;
generating, by the server, a prompt requesting a user initiating data synchronization to submit a password, wherein the data synchronization for the data table is password-protected by a correct password; and
in response to the password provided by the user matching the correct password, enabling the data synchronization without requiring password reentry for a predetermined time period;
mapping, by the server, the one or more corresponding updated records in the data file to one or more records in the data table by, for each updated record, matching the respective record identifier of the respective record identifiers in the data file to the respective record identifier in the data table; and
updating, by the server based on the enabling the data synchronization, the data table corresponding to the table email address by updating the one or more attributes of each corresponding record of the records in the data table with the one or more updated attributes of the corresponding updated record in the data file.