PipedreamHQ / PipedreamHQ/pipedream
[FEATURE] Google Sheets - Add rows as plain text
- Dominant language
- JavaScript
- Stars
- 11.7k
- Forks
- 5.8k
- Avg merge
- 3d 10h
- Merged PRs (30d)
- 102
Description
Hi,
Would like to request workflow V2 to maintain the feature of V1 by just adding the rows to Googlesheet as plain text.
Before:
Cell format before ex1

After:
Cell format after ex1

To add another issue, I noticed that if the content paste is not in plain text.
Example,
Cell B11-B23 has formula to sum the values of column F based on the column B content.
The original formula of cell B2:
=SUMIFS($F$28:$F$687, $B$28:$B$687, $A$12)
After running the workflow V2, the formula valued changed and values not included in the summation.
=SUMIFS($F$29:$F$688, $B$29:$B$688, $A$12)
Please refer to the earlier effort on the request if needed: https://github.com/PipedreamHQ/pipedream/issues/8389
Thanks.
Contributor guide
Assessment
This issue has not been assessed yet.