I set up a simple zap between Strava and GSheet.
whenever I record an activity on Strava I want to get some parameters on a new GSheet row.
one of these parameters is “Distance in K” (total distance in kilometers).
the problem is that it randomly changes in a strange <1 decimal number.
for example: I record a 14.2 Km run but the value I get in gsheet is something like 0,59
if I try to trigger this action (several times) in test mode from Zapier (Retest & Review), I sometimes get the right value in K
please note that the spreadsheet where I send the data is clean and I didn’t apply any weird cell format.
is there anyone who can help me fix this out?
Best answer by anybigideaView original
Can you show us a screenshot of how you’ve got the Google Sheets step configured in Zapier.
thanks for the support.. I just solved the issue.
it was basically a decimal separator problem between strava, which uses the “.” and my gsheet, wich is set to use “,”.
so whenever strava sent data, gsheet interpreted it in a time format (eg. 14.19 > 14.19.00) and subsequently tried to translate it in a number format (eg. 0,59).
since I have lots of data and other calculations on my spreadsheet which involve the decimal separator misalignment, I solved the issue with a substitute() function.