I'm trying to follow the tutorial to automatically create and publish surveys on python api. But when I use the Create() method under SurveyManager, it created an empty layer object with no data

Then when I use the publish function with an xlsx file, it gave me this error:
Spatial reference of layer 'Water_Quality_Survey' must be the same as defined by the service.
(Error Code: 500)
the survey created by the Create() function is also un-editable in webform

I was using the same code as the document; I'm so confuse on what is going on right now.