I have embarked on the task of creating a unique Google site that requires user login information at the onset. Upon successful login, the site displays a personalized profile derived from a fusion table containing business card data. However, I am encountering difficulties in comparing the email inserted by the user with the emails stored in the 'Email' column of the fusion table.
Is there a specific function within Google Apps Script that can retrieve the username input from the control panel for comparison purposes? This would enable me to accurately fetch and display the corresponding business card layout data on the Google site.
While exploring the fusiontables API, I couldn't find a direct solution to my current dilemma.